Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro call Sub UNPROTECT which unprotects a
worksheet. I want the user to run this with a button on the worksheet. If I use a button from the Forms toolbar it works fine, but when I call the macro from a button from the ControlBox toolbar I comes up with a runtime error? I'd like to use the controlbox button as they are more versatile and you can change the colour etc. the unprotect macro code is simply Worksheets(1).unprotect password:="HOLIDAY" Thanks in advance |