Macro - Reset button not working anymore

[heather1209]

Hello, my reset button was working until I added a code in the worksheet to change the name of the drop down menus depending on which list was chosen. The shortened version of the code I added to do this is (shortened because it goes from First to Fifteenth):

Please Login or Register  to view this content.

The macro I'm using for the reset button is:

Please Login or Register  to view this content.

and when I go to debug, it is saying that the following part has a "Run-time error '1004': Application-defined or object-defined error"

Please Login or Register  to view this content.

I'm attaching an example file so it's easy to see everything involved.

Please let me know what is going wrong. I'm not familiar at all with macros and VB, and this reset button is the last piece of this spreadsheet I need before it's finished!

[heather1209]

Alright, I got this fixed by changing this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

for a completed macro of:

Please Login or Register  to view this content.

But now it doesn't work when my sheet is protected. No errors, it's just that nothing happens when I click the Reset button. Do I have to change something in the macro to apply when the sheet is protected?

[watersev]

hi heather1209, if the sheet is protected you obviously need to uprotect it, do your actions and protect it again
example:

Please Login or Register  to view this content.

details can be checked in VB help file for Protect and Unprotect methods