protect macro

[evelin via OfficeKB.com]

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

 

[Dennis]

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

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.

 

[Don Guillett]

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

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

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.

 

[Barb Reinhardt]

I've seen how to do it for Worksheet and maybe workbook passwords, but not VB
passwords. How is that done?

 

[Gord Dibben]

You pretty much need a hex editor or a commercial application for VBA
passwords Barb.

See John McGimpsey's site.


Gord Dibben MS Excel MVP