Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide macro
Ho to all,
i have two macro. The first is set by workbook.open, the secon is called from the first and is placed in module1. I want to hide both so the user cannot see them from the excel sheet. What the solution? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide macro
Hi GM
if i'm understanding your question correctly, go into the VBE window (Alt & F11) and click on the project name, now right mouse click and choose VBAProject Properties, go to the protection tab and tick "locked for viewing" and enter a password (twice) click OK when the book is closed and reopened you will not be able to view the code without the password. However, please note, that protection in excel is relatively easy to break. Cheers JulieD "GM" wrote in message ... Ho to all, i have two macro. The first is set by workbook.open, the secon is called from the first and is placed in module1. I want to hide both so the user cannot see them from the excel sheet. What the solution? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide a Macro | Excel Discussion (Misc queries) | |||
macro to hide row with 0.00 | Excel Worksheet Functions | |||
Hide row macro | Excel Programming | |||
Macro to hide rows. | Excel Programming | |||
more help with a hide macro | Excel Programming |