View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] doodles82a@yahoo.com is offline
external usenet poster
 
Posts: 23
Default Disable Macro Alert

I have VBA Code attached to Workbook A. My VBA Code opens Workbook B
in order to extract certain information. Then, my code closes Workbook
B without saving any changes that might have occurred to Workbook B.

Workbook B includes macros. Because my security is set on Medium, I
get the Enable/Disable macro message.

In the same manner in which I can disable the UpdateLinks message, and
without changing my macro security setting, is there a line of code I
can use in Excel 2003 to disable the Enable/Disable macro message?

Thank you.