Please be aware that excel passwords are fairly easy to defeat.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dennis" wrote in message
...
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.