Hi NZuser,

If you move the macro from the existing workbook to your Personal.xls file (see Excel Help for details), that means only you will
have access to the macro. That's far more secure than anything you can do that involves distributing the macro with the file.

An alternative is to not hardcode the password into the protection macro but to solicit the password via an InputBox.

--
Cheers
macropod
[MVP - Microsoft Word]


"NZuser" wrote in message ...
Thanks for that, how do I lock it?
Is there a stronger protection?

"NZuser" wrote:

Hello,
I have a spreadsheet which I've added a macro button onto to quickly
password protect all worksheets, I send this spreadsheet out to others and
have realised they can easily access the macro and unprotect the worksheets,
is there any way I can protect the macro so others can't run it?
:-)