Thread: protect macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dennis Dennis is offline
external usenet poster
 
Posts: 1
Default protect macro

On Oct 31, 2:44*am, "evelin via OfficeKB.com" <u54234@uwe wrote:
I created a template in excel including vb macros
when users create new files on this template model *they must be able to use
macros also.
But is thee a way to *protect/hide macros

--
Message posted viahttp://www.officekb.com


To protect your VB code from being seen by others, all you need to do
is go to the project explorer, point at your project and right click
on it. Select VBA project properties, click on the protection tab and
check the Lock project for viewing and key your password. That's it.