Protected sheet and macros

[Jan Kalop]

I have protected worksheet without password and when I want run any one of many marcos on that sheet it dosen't allowe me because the sheet is protected.

Is there any way to keep worksheet protected and at the same time be able to run macros from that sheet?

 

[Peter_SSs]

Generally the best idea is in your macro, unprotect the sheet at the start of the macro and re-protect it again at the end of the macro. Could that work for you?

 

[Jan Kalop]

Generally the best idea is in your macro, unprotect the sheet at the start of the macro and re-protect it again at the end of the macro. Could that work for you?

yes that would be great, how this can be done?

 

[Peter_SSs]

yes that would be great, how this can be done?

The exact code would depend on exactly what protection you have on the sheet (eg password or no password, allowing or disallowing formatting, row insertion/deletion etc.)
Best way would be to turn on the macro recorder and then manually unprotect your sheet then re-protect it with the options you want then stop the macro recorder and look at the code.

 

[Jan Kalop]

The exact code would depend on exactly what protection you have on the sheet (eg password or no password, allowing or disallowing formatting, row insertion/deletion etc.)
Best way would be to turn on the macro recorder and then manually unprotect your sheet then re-protect it with the options you want then stop the macro recorder and look at the code.

Thankyou very much solve the problem after few attempt

 

[Peter_SSs]

You're welcome. Glad you were able to sort it out.