VBA Code Won't Run when I Protect Worksheet

[USFengBULLS]

Hello,
I am sure this is an easy question but would anyone know why I am getting a 1004 Runtime Error in my Code after I protected the Worksheets from the review Tab?
The code works fine when the sheets are unprotected, but I need to protect the worksheets so users can not adjust the formulas and contents of certain/most cells.
My code does work with a lot of these cells that are locked once Protected but I can't figure out why I am getting this Runtime 1004 error now.
Any Suggestions? Thanks.

 

[mumps]

Place your code between these 2 lines:

Activesheet.Unprotect
'your code here
Activesheet.Protect

This will unprotect the sheet, run the code and then protect it again.

 

[USFengBULLS]

Okay, but I broke it up into 4 different codes in my Module. Then use the Call function on the command button activeX and run all four at once.
How would that work?

 

[Mentor82]

Hi,
Use these statements in command button module

Activesheet.Unprotect
Call macro1
Call macro2
Call macro3
Call macro4
Activesheet.protect

Regards,
Sebastian

 

[USFengBULLS]

I just did that and used sheet3.Unprotect for the sheet the code copies content to from the active sheet. When I click the ActiveX Command Button it asks for the password for both sheets.

 

[Mentor82]

You did not mentioned you've got worksheets password protected. Use this...

Activesheet.Unprotect password:="Type in your password"
Call macro1
Call macro2
Call macro3
Call macro4
Activesheet.protect password:="Type in your password"

 

[USFengBULLS]

Sorry. But that did solve it for me.
Thanks so much