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?
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

run marco to send a excel file by email(lotus note) 1
CHANGE MARCO PROBLEM 1
msgbox question 2
Pls help on Shared WorkBook 1
Record Macro Excel 2007 1
Marco problem 1
simple but hard question 1
Merging Workbooks 3

Back
Top