protect marco

  • Thread starter Thread starter Wu
  • Start date Start date
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?
 
I have a file contains some marco which dont want to be read by other person.

How can I set the marco unread?

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
 
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.
 
Back
Top