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

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

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

How to prevent anyone from viewing the code
 

Thanks:)