Macro Message

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

Is there some way to turn OFF the message you get when you
open an Excel file that has macros asking whether you want
to enable or disable them???

Thanks
Frank
 
Hi Frank,

Probably "you can purchase a digital signature (verisign,
etc...)" from Dan's message is your best bet. The only
alternative I know of is to use send keys, but you'll have
to adjust the key string for the Excel version in use.
Custom menus can be an issue here too.

Best Regards,
Walt
 
Frank,

I'd like to be able to help you, but unfortunately, on
my machine (Win 98, XL 2000) your code does not
produce an "Enable/Disable macro message" with
my security set to medium. Opening the file produces
the message, but not when done by your code???

Dan E
 
Back
Top