macro protection
 

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

macro protection
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


leigh wrote:
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