protect marco
 

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

How can I set the marco unread?

protect marco
 

On 2 Dec, 12:17, Wu wrote:
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

protect marco
 

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.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
On 2 Dec, 12:17, Wu wrote:
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