Turn Off Macro Warning

T

Tiziano

I wrote a small macro for a worksheet. Every time I load the
workbook into memory --there is only one worksheet in it-- a
window pops up asking me whether or not I want to run the macro.
Is it possible to turn off the macro warning window for a specific
workbook (or worksheet) with some VBA line of code? How?
 
K

keepITcool

Nope. It depends on the Macro Security Level the user has set.
Ofcourse this cannot be set with code..
it would defeat it's purpose wouldn't it..



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tiziano wrote :
 
E

Elmer Smurdley

In Excel 2000, goto "Tools", "Macros", "Security" and set
to "Low".

In Excel XP Pro, goto "Tolls", "Options", "Security".
 
A

Amedee Van Gasse

keepITcool said:
Nope. It depends on the Macro Security Level the user has set.
Ofcourse this cannot be set with code..
it would defeat it's purpose wouldn't it..
Click to expand...

Get a digital signature.
You could use something expensive like from Verisign, or if it's just
for personal use, locate selfcert.exe on the Office installation cd and
search the Excel help for more info. It's in there, really!
 
Top