Pop up message if marcos are disabled

  • Thread starter Thread starter The Grinch
  • Start date Start date
T

The Grinch

Hi All,

Is there anyway to force a simple pop up message every time
particular spreadsheet is opened ONLY IF the user opening it has macro
disabled?

The pop up message needs to be of the form...
'You have macros disabled' [with one 'OK' button]

Any help would be greatly appreciated

CHEERS
The Grinc
 
No, that would require macros to be enabled.

Instead, you might want to consider a "splash screen" worksheet:

Create a sheet that includes your text (perhaps along with instructions
for how to reenable them). Then hide the rest of your worksheets. Use
the Workbook_Open() event macro to unhide your sheets and hide your
splash screen. Use the Workbook_BeforeSave() event macro to hide your
sheets, unhide your splash screen, save the file, then unhide your
sheets and hide your splash screen.
 
Back
Top