Macros don't run with protected sheet

[Juan Carlos]

Hi everyone.

I'm new on this site, I registered a few mins ago so this is my first post/question, I hope someone can help me on this. I'm new to Macros, and VBA etc, so I hope to ask in a understandable way for you guys.

Long story short, I created this excel project on which I have added different macros for different functions. I do not know how to program on VBA (although it looks kinda similar to GWBasic, if you know what I mean), so all I have done is "copy" and "paste" the codes from the internet for the functions I want on my excel proect, and everything has worked really great.

Until I password-protect the sheet.

I've read a lot of different posts on different sites and basically, I've tried everything! Everything and each and every single time I protect the sheet, no matter what codes I have used, I still can't make macros to run under the protected sheet...

Every time I get this error message. Something about "1004" and when I click the button to go to the VBA editor (my excel is in Spanish 'cause I'm Mexican (no beaner or green cards jokes here please thanks ) it highlights in yellow background different things. Sometimes it shows me a Range, sometimes an ActiveCell, etc.

So, my question is: Is there a way to ACTUALLY password-protect your sheet to prevent users to modify or delete formulas etc. AND make all the macro's work still, without seeing that runtime 1004 error or something?

ANY ideas on this will be HIGHLY appreciated.

Greetings from Mexico, and sorry'bout my English and long post!

[HaHoBe]

Hi, Juan Carlos,

you might use the approach to unprotect the sheet, run the code and protect the sheet again at the end.

Another way would be to use the parameter UserInterfaceOnly:=True which is volatile but would allow all macros to run while any user canīt change the data. This command will not be saved with the workbook and needs to be set on opening the workbook or activating thesheet.

Ciao,
Holger