View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Hiding macro-enabled password

Password protect your project.

Tools - VBA Project Properties - Protection Tab
Check lock project for viewing and supply a password.

This type of password is reasonably secure from being hacked. Note that the
password for the worksheet or workbook are relatively easy to hack with code
easily available on the net.
--
HTH...

Jim Thomlinson


"Brad E." wrote:

I set up my macro to password protect the worksheet and sent the worksheet
on. One user told me what my password is. He simply went to the VBA screen
and saw WS.Protect Password = "MyPassword".

How can I avoid this in the future?

TIA, Brad