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 via http://www.officekb.com

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.

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.

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

"Don Guillett" wrote:

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.

.

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

On Sat, 31 Oct 2009 16:29:01 -0700, Barb Reinhardt
wrote:

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

"Don Guillett" wrote:

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.

.