How do I become trusted

[Keith]

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 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?

 

[Stan Brown]

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.

 

[Keith]

Thanks Stan,

I thought that might be the answer.

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

 

[Chip Pearson]

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)