How do you suppress macro warnings?

  • Thread starter Thread starter John Google
  • Start date Start date
J

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
 
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>
 
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.
 
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.
 
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.
Click to expand...

I wouldn't want to set security level to Low as this suppresses all
warnings to users for any workboook.
 
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)
 
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.
|
|
 
Back
Top