Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preventing User Access to VB code
Hi:
is there a way to prevent user access (password?) to the VB code in an Excel workbook? I have already restricted the tool bars and menu but I would like to prevent users from trying to see the VB code. thanks --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preventing User Access to VB code
Right-click the module you want to protect, select VBAProject properties.
Select the protection tab and type a password in the box. -- If I've mis-understood the question please tell me. HTH ijb Remove nospam from my e-mail address to talk direct Not MCSD, MVP, TLA, P&P, PCMCIA, etc just trying to help "halem2 " wrote in message ... Hi: is there a way to prevent user access (password?) to the VB code in an Excel workbook? I have already restricted the tool bars and menu but I would like to prevent users from trying to see the VB code. thanks --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preventing User Access to VB code
You've been given an answer for how to password protect you code.
However, you should know that this password protection provides only a slight amount of real protection. Anyone with enough gumption to find these newsgroups can find multiple ways to bypass your restrictions. Usually with only a few seconds' work. Excel's internal protection isn't worthy of the name. Instead, you may want to consider protecting your code by including it in a compiled COM add-in. In article , halem2 wrote: is there a way to prevent user access (password?) to the VB code in an Excel workbook? I have already restricted the tool bars and menu but I would like to prevent users from trying to see the VB code. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preventing user input for individual cells | Excel Worksheet Functions | |||
PREVENTING ACCESS TO A HIDDEN COLUMN | Excel Discussion (Misc queries) | |||
Preventing an excel file from being deleted by another user | Excel Discussion (Misc queries) | |||
Preventing a user name in comments | Excel Discussion (Misc queries) | |||
Problems with preventing the user of setting a checkbox of a treeview | Excel Programming |