Bypassing macro warning messagebox

[K. Georgiadis]

A macro-containing workbook that I have prepared will be
used by several other colleagues. I think the message box
that appears upon opening the workbook is likely to throw
some of them off. Instead of asking them to change their
security settings, is there a way to disable this
messagebox?

 

[RWN]

I hope not, or it would be rather redundant wouldn't it(?).

 

[Harald Staff]

Hi

Sign it with selfcert.exe. Now it will say

This workbook contains macros by K. Georgiadis

which is more trustworthy, and they can add you to their "trusted source"
list to avoid further prompts.

http://support.microsoft.com/default.aspx?scid=kb;en-us;217221

HTH. Best wishes Harald

 

[Macroman]

Just tell your colleagues to set their macro security to
low before opening your workbook.

There is a way to turn it of other users machines. I do
not know exactly but it involves using an exe or zip file
that when executed, sends an xla (or xls)to the office
startup folder, basically "Sub Auto_Open() security=low"

But Don't do this. You might end up in jail for computer
malpractice.