Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can you hide macro code??
Hi,
I have some user forms and there is macro code associated with them. Is it possible that the user be UNABLE to see the code? ie. the code be inaccessible to them? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
can you hide macro code??
In VBA editor, select from menu bar
Tools/VBA Project Properties .../Protection tab, check the box "Lock project for viewing" and add a password. CAUTION: This is not secure. Password crackers for this level of security are ten a penny. Better to compile your code as an add-in. Don't ask me how to do that. wrote in message ... Hi, I have some user forms and there is macro code associated with them. Is it possible that the user be UNABLE to see the code? ie. the code be inaccessible to them? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
can you hide macro code??
Hi,
In VB, choose Tools, Properties, Protect. There you can choose your password, and then you make sure to choose option "Hide". Close the program, open it again and press F11 to get to VB. Now you have to write your choosen password to be able to see the code. //Thomas skrev i meddelandet ... Hi, I have some user forms and there is macro code associated with them. Is it possible that the user be UNABLE to see the code? ie. the code be inaccessible to them? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro or VB code to hide and unhide Label box | Excel Discussion (Misc queries) | |||
Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
hide code does not hide | Excel Discussion (Misc queries) | |||
Macro/code to hide rows | Excel Worksheet Functions | |||
Hide VBA code help | Excel Worksheet Functions |