Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting / Hiding the Code
Hey everyone, I need to find out how to hide the VB code
behind an Excel Workbook. Is it possible to protect it via password? Can the code be made inaccessible to the users? Please advise DBAL |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting / Hiding the Code
Hi
in the VBA editor right-click on your project name, choose VBA properties and assign a password. Note: This kind of protection is very weak. There's no way to really protect VBA code. -- Regards Frank Kabel Frankfurt, Germany "DBAL" schrieb im Newsbeitrag ... Hey everyone, I need to find out how to hide the VB code behind an Excel Workbook. Is it possible to protect it via password? Can the code be made inaccessible to the users? Please advise DBAL |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting / Hiding the Code
In VBA, go to the Tools menu, choose VBA Project Properties then
the Protection tab. There, check the "Lock project for viewing" option and enter a password. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DBAL" wrote in message ... Hey everyone, I need to find out how to hide the VB code behind an Excel Workbook. Is it possible to protect it via password? Can the code be made inaccessible to the users? Please advise DBAL |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting / Hiding the Code
Thanks a million. When I was in there looking at what
Frank said I saw that. Thanks again! It works. -----Original Message----- In VBA, go to the Tools menu, choose VBA Project Properties then the Protection tab. There, check the "Lock project for viewing" option and enter a password. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DBAL" wrote in message ... Hey everyone, I need to find out how to hide the VB code behind an Excel Workbook. Is it possible to protect it via password? Can the code be made inaccessible to the users? Please advise DBAL . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting / Hiding the Code
Thanks alot man. That was the ticket! DBAL
-----Original Message----- Hi in the VBA editor right-click on your project name, choose VBA properties and assign a password. Note: This kind of protection is very weak. There's no way to really protect VBA code. -- Regards Frank Kabel Frankfurt, Germany "DBAL" schrieb im Newsbeitrag ... Hey everyone, I need to find out how to hide the VB code behind an Excel Workbook. Is it possible to protect it via password? Can the code be made inaccessible to the users? Please advise DBAL . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding and protecting formula | Excel Discussion (Misc queries) | |||
Protecting and Hiding formulas | New Users to Excel | |||
Protecting buttons with VB code rather than protecting sheets/books? | Excel Programming | |||
Hiding/Protecting the code of macro | Excel Programming | |||
Hiding/Protecting vb code in excel | Excel Programming |