Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you lock macros
Is there anyway that you can lock macros and prevent from people seeing them?
Thank you in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you lock macros
In VBA, go to the Tools menu, choose VBAProject Properties, then the
Protection tab, check Lock Project For Viewing and enter a password. Note that the security is very weak. I use VBAKey from Passware and it can break a VBA password in seconds. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "SAM SEBAIHI" wrote in message ... Is there anyway that you can lock macros and prevent from people seeing them? Thank you in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you lock macros
WOW! Thank you so much Chip
Protection tab, check Lock Project For Viewing and enter a password. Note that the security is very weak. I use VBAKey from Passware and it can break a VBA password in seconds. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "SAM SEBAIHI" wrote in message ... Is there anyway that you can lock macros and prevent from people seeing them? Thank you in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
How can I lock worksheets while macros can still enter into them? | Excel Discussion (Misc queries) | |||
How can I lock worksheets while still allowing macros to operate? | Excel Discussion (Misc queries) | |||
How can I lock worksheets while still allowing macros to operate? | Excel Discussion (Misc queries) |