hiding macro codes upon protecting the worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I hide macro codes upon protecting the worksheet? I don't want other
users to see my codes, how will I do that?
 
Inside the VBE
select your project
Tools|VBAProject Properties|Protection tab

give it a memorable password.

This is 100% foolproof, but it'll keep most out.
 
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

Macro to hide worksheet based upon text in the name 5
Protect and Unprotect all worksheets with macro 2
Hide Code 3
Enable outlining in a protected worksheet 8
hide, unhide column or row after protect worksheet 4
Hide and lock cell formulas without affecting Macro? 4
Macro to hide sheets based upon cell value 3
worksheet protection 3

Back
Top