How do you suppress macro warnings?

[John Google]

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

 

[Jim Rech]

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>

 

[John Google]

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.

 

[Guest]

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.

 

[John Google]

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.

 

[Bob Phillips]

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

--
HTH

Bob

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

 

[Jim Rech]

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.


--
Jim
| 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.
|
|