Excel97 CopyWorksheet Problem
 

Please Help! I am very new to VBA...

I have a Submission Form Worksheet which contains 3 buttons that I hav
written vba to do different things on click. When I use the code belo
to copy the contents of the worksheet to a new worksheet (in Excel 97
the buttons show up on the new worksheet but don't do anything. I
there a way to make the buttons work on my new worksheet?

I am using:
Worksheets("Submission Form").Copy After:=Worksheets("Submissio
Form")

Also, I have a button called delete. It should unprotect the curren
sheet so the user can delete an object on the sheet that is protected
My code is ActiveSheet.Unprotect. When I run it I get an erro
"unprotect method of worksheet class failed". Can anyone tell me wh
and how to fix?

Thanks so much in advance!!

--
Message posted from http://www.ExcelForum.com