protect marco

W

Wu

I have a file contains some marco which dont want to be read by other person.

How can I set the marco unread?
 
S

Steve

I have a file contains some marco which dont want to be read by other person.

How can I set the marco unread?
Click to expand...

you need to set a password in the VB projects window.

Alt - F11, Tools , VBAproject Properties, Protection and make sure the
'Lock project for viewing' has a tick


Steve
 
D

Don Guillett

To make it unseeable use
Private Sub mysub()
or option private module as the first line in the module
Be aware that it is fairly easy for anyone with knowledge to break your
password.
 
Top