If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Prevent access to macro's if sheet is password protected
Hi
within the VBA editor try the following: - right-click on the project name - click on 'Properties' - set a password -- Regards Frank Kabel Frankfurt, Germany 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/ |
#2
|
|||
|
|||
Prevent access to macro's if sheet is password protected
Alt&F11
View Project Explorer Right Click on the Project / Properties / Protection Dennis =========== In article , sonar wrote: 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/ |
#3
|
|||
|
|||
Prevent access to macro's if sheet is password protected
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. In article , sonar wrote: 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? |
Thread Tools | |
Display Modes | |
|
|