Type Mismatch error ==> do some code before exiting sub

[drawing.blanks]

Hi,

Below is a segment of my code it:
1. unprotects the sheet with password
2. asks the user to input an integer
3. executes the body of the code
4. protects the sheet with password

If the user hits the Escape key or click the Cancel button in step 2, I get the Type Mismatch error but the sheet is still unprotected.

How can I protect the sheet with the password before exiting the macro. Thanks.

Please Login or Register  to view this content.

[JapanDave]

Give this a whirl,

Please Login or Register  to view this content.