Strange you did not receive a lot of answers...
You should lock your project to prevent accessing the code. However, be
aware that this is a weak protection.
HTH
Daniel

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?
:-)