View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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