hello,

I have a button on one of my worksheets, and I don't want it to be used if the sheet is protected.

Currently, if you click the button, and the sheet is protected, then it outputs "Run time error 1004: cannot use this command when the sheet is protected" (or something of that sort).

How can I catch this error, so that instead of this error coming up, a message box comes up informing the user to first unprotect the sheet?

Please Help