View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Turn Off Macro Warning


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 :

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