Run macros in protected sheets

[scara]

I want to protect all sheets in my workbook except for a few cells. When I do this I still want to be able to run my macros.

How do I do this?

[Aquila]

Hello scara,

Put this code in "This Workbook" using VB

Please Login or Register  to view this content.

[royUK]

You can either add a line to the start of the code to unprotect the sheets, then restore protection at the end, or use ProtectWithUserInterface

[scara]

follow up question. How do I write this code if I only want shhe3 shhet to be protected?

[Domski]

if I only want shhe3 shhet to be protected?

Must be cold in Sweden, are you shhhhivering

Dom

[royUK]

Do you mean

Please Login or Register  to view this content.

[scara]

Not quite I get an error message, run time error object required. please help with the whole code

Please Login or Register  to view this content.

Maybe it is something like

Please Login or Register  to view this content.