macro protection

  • Thread starter Thread starter leigh
  • Start date Start date
L

leigh

I have a worksheet that is protected, it has a macro that
applies to the worksheet. Problem is that if someone edits
the macro it contains the password for the worksheet
protection. Is there any way to protect or hide the macro
so they cannot see the password?

Leigh
 
Hi
one way (though it can easily be overcome'):
- in the VBA editor right-click on your project name
- choose 'Properties - Protection'
- choose a password
 

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 do i password protect my VB Code from users 2
including macro in protected worksheet 2
How to Unlock Excel Workbook protected by MACRO Password 6
Protect Macro 3
Copying in sheet with protection with the use of a macro 5
Macro to open view with a password 3
Copy data using macro (with worksheet protect) 5
random number generated password 1

Back
Top