We have just moved all our machines to Office 2007 and are having a few
problems as you might imagine.

My biggest issue is with macros. A vast majority of our spreadsheets use
macros, but the users keep either forgetting to select options then enable
content or they say the options button doesnt appear.

How can I have all our company files set so the macros are enabled without
making all macros enables regardless where they come from?

Tue, 8 Jan 2008 01:47:01 -0800 from Keith
:
My biggest issue is with macros. A vast majority of our spreadsheets use
macros, but the users keep either forgetting to select options then enable
content or they say the options button doesn?t appear.

How can I have all our company files set so the macros are enabled without
making all macros enables regardless where they come from?

You can buy a digital certificate from Verisign or one of the other
providers. It's not cheap. Even so, that won't give your macros any
special trust level higher than those from other third parties who
have certificates. I believe that most commercial Excel add-ins do.

I think a better solution is to train your users better, though I
recognize that's not a trivial task.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

Thanks Stan,

I thought that might be the answer.

As for training user. It would be easier to train monkies some times. :-)


"Stan Brown" wrote:

Tue, 8 Jan 2008 01:47:01 -0800 from Keith
:
My biggest issue is with macros. A vast majority of our spreadsheets use
macros, but the users keep either forgetting to select options then enable
content or they say the options button doesn?t appear.

How can I have all our company files set so the macros are enabled without
making all macros enables regardless where they come from?

You can buy a digital certificate from Verisign or one of the other
providers. It's not cheap. Even so, that won't give your macros any
special trust level higher than those from other third parties who
have certificates. I believe that most commercial Excel add-ins do.

I think a better solution is to train your users better, though I
recognize that's not a trivial task.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

You can also create your own digital signature using SelfCert, at
Application.Path & "\SelfCert.exe". It isn't from a trusted source, but it
may be all you need.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Keith" wrote in message
...
Thanks Stan,

I thought that might be the answer.

As for training user. It would be easier to train monkies some times. :-)


"Stan Brown" wrote:

Tue, 8 Jan 2008 01:47:01 -0800 from Keith
:
My biggest issue is with macros. A vast majority of our spreadsheets
use
macros, but the users keep either forgetting to select options then
enable
content or they say the options button doesn?t appear.

How can I have all our company files set so the macros are enabled
without
making all macros enables regardless where they come from?

You can buy a digital certificate from Verisign or one of the other
providers. It's not cheap. Even so, that won't give your macros any
special trust level higher than those from other third parties who
have certificates. I believe that most commercial Excel add-ins do.

I think a better solution is to train your users better, though I
recognize that's not a trivial task.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/