Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide VB Scripts & macro from user
Is there a way to prevent the user from viewing VB scripts and Macros. The
reason I ask is that I have a protected sheet and I have passowrds coded into the scripts that I want to prevent the user from seeing. eg. Sub auto_open() With Worksheets("Passive Safety") .Protect Password:="password", userinterfaceonly:=True .EnableOutlining = True End With End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide VB Scripts & macro from user
In the VBA window, go to VBAProject Properties and then the tab named
"Protectioon and add a password. When you next reload the excel file you will not be able to get access to the macros without the password, or a cracking plug in. But for basic security it does the trick. "Ram B" wrote: Is there a way to prevent the user from viewing VB scripts and Macros. The reason I ask is that I have a protected sheet and I have passowrds coded into the scripts that I want to prevent the user from seeing. eg. Sub auto_open() With Worksheets("Passive Safety") .Protect Password:="password", userinterfaceonly:=True .EnableOutlining = True End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking multiple scripts by user OK | Excel Programming | |||
Hide columns to all but one user? | Excel Discussion (Misc queries) | |||
how can I hide macro list from user? | Excel Programming | |||
VBA code scripts in macro | Excel Programming | |||
Hide code from user | Excel Programming |