How do you suppress macro warnings?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Google - 11 Nov 2007 21:45 GMT

Hi,

For those of you who work with small companies that create
spreadsheets containing VBA macros, how do you handle the warning that
Excel displays when you open a workbook?

I know you can use SelfCert.exe to create a personal digital signature
but as far as I can tell, this only works for your own PC. When the
workbook is opened on another computer by another user the warning
appears again.

Getting a digital certificate from VeriSign etc for $499 per year will
be OTT for a lot of small companies.

In the real world, what do small companies with a handful of employees
do?

Thanks in anticipation!

JohnGoogle

Reply to this Message

Jim Rech - 11 Nov 2007 21:58 GMT

>>In the real world, what do small companies with a handful of employees do?

They tell their users that they should enable macros when open running an
in-house application if they want it to be functional. Been working
perfectly for years in my company.<g>

Signature

Jim

> Hi,
>
[quoted text clipped - 16 lines]
>
> JohnGoogle

Reply to this Message

John Google - 11 Nov 2007 22:52 GMT

Thanks Jim.

I've only developed workbooks for techie people up to now but I hope
to be working for a local council soon. They have simple spreadsheets
(and users!) at the moment and a lot of manual work. I am hoping to
automate a lot of it by auto creating workbooks to split data by week/
month etc which will require VBA macros.

I was wondering how their IT department would see this 'problem'.

JohnGoogle.

Reply to this Message

Ian - 11 Nov 2007 23:28 GMT

If it's saved in a common folder -- Tools>>Options>>Security>>Macro
Security>>Low but I don't know if it's different for each user. Sorry.

> Thanks Jim.
>
[quoted text clipped - 7 lines]
>
> JohnGoogle.

Reply to this Message

John Google - 12 Nov 2007 08:29 GMT

> If it's saved in a common folder -- Tools>>Options>>Security>>Macro
> Security>>Low but I don't know if it's different for each user. Sorry.

I wouldn't want to set security level to Low as this suppresses all
warnings to users for any workboook.

Reply to this Message

Bob Phillips - 12 Nov 2007 08:47 GMT

You either sign workbooks, get users to enable macros, or set the security
to low. Those are your options.

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>> If it's saved in a common folder -- Tools>>Options>>Security>>Macro
>> Security>>Low but I don't know if it's different for each user. Sorry.
>
> I wouldn't want to set security level to Low as this suppresses all
> warnings to users for any workboook.

Reply to this Message

Jim Rech - 12 Nov 2007 11:48 GMT

>>but I hope to be working for a local council soon.

I would think the IT dept is pretty familiar with a macro virus warning and
consider it a minor training issue for users who haven't seen one before.

Signature

Jim

| Thanks Jim.
|
[quoted text clipped - 7 lines]
|
| JohnGoogle.

Reply to this Message

Rate this thread: