How do I protect a sheet if there is an error on a userform?

[jfoerch]

Hi All,
Currently, when I open a userform, I use the userform initialize() command to unportect a sheet and then userform terminate() to re-protect those sheets. Is there an alternative command that I can use so that the sheets are re-protected if there is a error on the userform?

This is the code I use to unprotect the sheeet. This works properly.

Please Login or Register  to view this content.

This is what I use to re-protect the sheet once the userform is terminated. This works properly.

Please Login or Register  to view this content.

This is what I was trying to use but didn't work.

Please Login or Register  to view this content.

Thanks

[HaHoBe]

Hi, jfoerch,

have you tried using the parameter UserInterfaceOnyl:=True when protecting the sheet (this would allow macro code to run bzt no action from the normal interface)? Please mind that this is a volatile setting and is not saved with teh file.

Maybe use

Please Login or Register  to view this content.

Alternative may be to have an error handler in the code with On Error GoTo Handle_err and protect the sheet in there again before ending the UF.

Ciao,
Holger