Protect Macro from Edit

  • Thread starter Thread starter Bin
  • Start date Start date
B

Bin

How to use a password to protect my Macro that can be Run
only by others but not Edit?
 
Hi
- goto the VBA editor (ALT + F11)
- right-click on your project name and choose 'Properties'
- enter a password in the appearing protection dialog
 
Hi Bin!

In the VBE Project Explorer select the project then:

Tools > VBA Project Properties > Protection
Give and confirm password

Don't forget the password as they are more difficult to crack.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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

How to Unlock Excel Workbook protected by MACRO Password 6
How do i password protect my VB Code from users 2
Novice - using macro to protect with password 10
Excel Protection 2
Run Macro If Cell have "x" value 0
How to hide macro so as to protect them from editing 1
preventing referencing hidden cell 3
Marco to protect / unprotect worksheet 2

Back
Top