sheet protect runtime error 1004

**aussietom** · 03-23-2013, 12:28 AM

hi guys just started up up on my eating plan and im very close to being done (on and off here and there)
now i have a vb code that pulls up information into a comment when a food is selected from a drop dow box.
after i sheet protect my workbook when ever i do so it comes up with the runtime error 1004 and sends me to the vb side of excel. is there any way to get around this?
also on saturday and sunday pages i done something i cant pull up all the info in a drop down box (its sending me crazy)
workout2.xlsm

**aussietom** · 03-23-2013, 12:37 AM

the sat/sun part fixed

**aussietom** · 03-23-2013, 05:50 AM

any help on the error guys?

**:) Sixthsense :)** · 03-23-2013, 08:31 AM

I am unable to understand what issue you are facing

But I am afraid you are using the sheet change event code on each sheets which can be done in a single code in ThisWorkbook Code.

Copy and paste the below code in THISWORKBOOK alone and remove all the code which you made in every sheets

Please Login or Register  to view this content.

**Taislin** · 03-23-2013, 09:07 AM

Hi... i think what is missing in your code is this:

Sheets("Sheet1").Unprotect Password:="PasswordGoesHere"
'Rest of your code goes here
Sheets("Sheet1").Protect Password:="PasswordGoesHere"

add this to your code and you will get the error 1004 out.