How to prevent anyone from viewing the code

S

Shilps

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
 
M

Mike Fogleman

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 said:
Hi,
I have created a tool and protected it. So now noone can change it but I
Click to expand...
want to disable anyone from even viewing it. How should I do it?
 
D

Don Guillett

Perhaps you should also know that this doesn't take effect until you save
the workbook>close>re-open.
 
Top