| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to prevent anyone from viewing the code
Hi
I have created a tool and protected it. So now noone can change it but I want to disable anyone from even viewing it. How should I do it TI Shilps |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to prevent anyone from viewing the code
With the workbook open and the VBEditor open, on the VBEditor tool bar
select Tools/VBAProject Properties/ and then the Protection tab to set whether it can be viewed and password. Mike F "Shilps" wrote in message ... Hi, I have created a tool and protected it. So now noone can change it but I want to disable anyone from even viewing it. How should I do it? TIA Shilps |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to prevent anyone from viewing the code
Perhaps you should also know that this doesn't take effect until you save
the workbookclosere-open. -- Don Guillett SalesAid Software "Mike Fogleman" wrote in message news:hn5kc.55559$GR.7506359@attbi_s01... With the workbook open and the VBEditor open, on the VBEditor tool bar select Tools/VBAProject Properties/ and then the Protection tab to set whether it can be viewed and password. Mike F "Shilps" wrote in message ... Hi, I have created a tool and protected it. So now noone can change it but I want to disable anyone from even viewing it. How should I do it? TIA Shilps |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to prevent anyone from viewing the code
Thanks:)
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting Sheet to Prevent Viewing | Excel Discussion (Misc queries) | |||
| hide a page and prevent outside users from viewing it. | Excel Discussion (Misc queries) | |||
| Protecting Sheet to Prevent Viewing At All | Excel Discussion (Misc queries) | |||
| can you prevent viewing of specific columns in a worksheet | Excel Worksheet Functions | |||
| HELP - Need to prevent others from viewing my MACRO LIST - How do I do this? | Excel Programming | |||
Linear Mode
