Bypassing macro warning messagebox

K

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

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