Prevent access to macro's if sheet is password protected

[sonar]

Hi,

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

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

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

 

[Frank Kabel]

Hi
within the VBA editor try the following:
- right-click on the project name
- click on 'Properties'
- set a password

 

[Dennis]

Alt&F11
View Project Explorer
Right Click on the Project / Properties / Protection

Dennis
===========

 

[JE McGimpsey]

You've gotten other replies on how to protect your code. Make sure,
though, that you don't expect real security out of protecting either the
sheet or the code. Both protections can be broken within seconds using
readily available free or low-cost tools.