add as userform. you can set a password character in a
textbox = if the pwd is not OK then you can raise a
warning

Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
Hi,
I have a workbook with two sheets...one visible to all
and one for
maintenance. I have written two macros...one to hide the
maintenance sheet
(amongst other things), the other to unhide them. They
are then activated by
clicking the relevant buttons that I have created on the
face of the visible
sheet.
What I now need to do is password protect these buttons
so that if an
unauthorised user clicks on them, XL prompts for a
password.
Any suggestions?
Also, although I am building the workbook in XL XP, the
solution needs to
also work in '97 and 2000 if possible due to the users
requirements.
Regards
Colin Foster


.