Hi all,

I have an addin that I cannot remove or disable that is interfering
with the before save event. Everything runs but the thisworkbook.save
line does nothing. I want to take control of the event to put a nice
splash screen warning that macros should be enabled before the save
and hide them afterwards. The workbook open event hides them provided
macros are enabled. The macro is as follows;

Application.ScreenUpdating = False
ActiveSheet.Shapes("shpmacro").Visible = True
Application.EnableEvents = False
ThisWorkbook.Save <==== doesnt actually save the
workbook
Application.EnableEvents = True
ActiveSheet.Shapes("shpmacro").Visible = False
Application.ScreenUpdating = True
ThisWorkbook.Saved = True

I dont want to use the before close event as myself I hate it when a
workbook saves when I dont expect it to. ie I like to muck around
with a sheet and if I dont like it close without saving.

Is there another way to save the workbook or provide a nice message
to politely ask the user to allow the macros


Stex