Thread: Can Add-in determine if macros enabled in another workbook?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anthony Berglas Anthony Berglas is offline
external usenet poster
  
Posts: 23
Default Can Add-in determine if macros enabled in another workbook?
Ie. The add-in (ThisWorkbook) is enabled (otherwise the exercise is
pointless) but are the macros in the ActiveWorkbook enabled?

(I want to know this to warn the user about the fact that Excel 95
Dialogs do not work if the Active workbook has Macros and they are
disabled (even though those ActoveWorkbook macros are never actually
called). A bug in Excel 2007.)

Anthony
Reply With QuoteReply With Quote