Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile VBA code
Is it possible to protect the VBA code underneath an
application built in Excel? I have written lost of code and built many forms for users to interact with my spreadsheet but I do not want them to be able to view or change any of the VBA code. How can this be accomplished? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile VBA code
Eric,
written "lost" of code ??? I've written "lost" of code myself. It works well, but I am "lost" as to what it does or how I even created it in the first place. From the VBA Editor... Tools/VBA Project Properties Protection Tab Select "Lock Project for Viewing" Enter Passwords. Please note that this will only protect your code from the casual user. Anyone with any experience in Excel (or anyone that can ask how to unprotect your project in the ng's) will probably be able to find out how. John "Eric" wrote in message ... Is it possible to protect the VBA code underneath an application built in Excel? I have written lost of code and built many forms for users to interact with my spreadsheet but I do not want them to be able to view or change any of the VBA code. How can this be accomplished? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compile | New Users to Excel | |||
Won't Compile | Excel Discussion (Misc queries) | |||
Compile VBA code? (Passwording too weak a protection scheme?) | Excel Discussion (Misc queries) | |||
Compile Error in Code | Excel Programming |