Prevent access to macro's if sheet is password protected

Hi,

I have a macro that includes my password to unprotect and run macro and
then password protect the sheet again when its finished running the
macro.

But I see that when the sheet is password protected, a person still has
access to the macro and thus are able to view the password, in order to
unprotect the spreadsheet.

How can I prevent someone from getting into the macro to view the
password?


---
Message posted from http://www.ExcelForum.com/