Quicker way to enable macros?

[Robert Crandal]

We use Excel 2010 and the majority of our programs are
"macro enabled" files. This means that each new user on our
network must manually enable macros by going into Excel's
"Trust Center->Macro Settings" section and check off
"Enable all macros", etc...

To be honest, setting up the macro settings in Excel is very
easy for myself. But... I'm curious if there's a faster way to
automatically enable macros so users can skip the step of
enabling macros.

Are there alternative (or faster ways) to enable Excel
macros??

Thanks.

 

[GS]

We use Excel 2010 and the majority of our programs are

"macro enabled" files. This means that each new user on our
network must manually enable macros by going into Excel's
"Trust Center->Macro Settings" section and check off
"Enable all macros", etc...

To be honest, setting up the macro settings in Excel is very
easy for myself. But... I'm curious if there's a faster way to
automatically enable macros so users can skip the step of
enabling macros.

Are there alternative (or faster ways) to enable Excel
macros??

Thanks.

There's not really any way to access macro security other than through
the UI dialog. I use VB6 automation for most of my stuff because
macro security is turned off and addins are not installed. AFAIK,
manual setting is the only way!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[witek]

We use Excel 2010 and the majority of our programs are
"macro enabled" files. This means that each new user on our
network must manually enable macros by going into Excel's
"Trust Center->Macro Settings" section and check off
"Enable all macros", etc...

To be honest, setting up the macro settings in Excel is very
easy for myself. But... I'm curious if there's a faster way to
automatically enable macros so users can skip the step of
enabling macros.

Are there alternative (or faster ways) to enable Excel
macros??

Thanks.

Check if it can be modified by GPO

 

[Bob Flanagan]

If you put your code in add-ins and then set the add-ins to auto-load (File, Options, Add-ins, GO button beside "Manage Excel Add-in", then the user doesn't need to worry about enabling macros. And, by separating your code from your data workbooks, you can update the code without worrying about thedata. And with macros workbooks, you can easily add custom tabs to the ribbon for ease of access.

Robert Flanagan
Add-ins.com LLC
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, fax 302-234-9859
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel