Protecting a document with VBA code help needed

[josnow]

Hi!

I would like to protect my excel document with VBA code.

When I try to protect it and then use the UserForm I created I get error or debug messages however the UserForm works perfect when it isn't protected.

Any help is greatly appreciated.Thank you in advance-Josnow

 

[cstimart]

Hi!

I would like to protect my excel document with VBA code.

When I try to protect it and then use the UserForm I created I get error or debug messages however the UserForm works perfect when it isn't protected.

Any help is greatly appreciated.Thank you in advance-Josnow

Can you code it so that it unprotects the document at the start of the process and re-locks at the end?