View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default WorkbookBeforeSave Problem

Excel 2007

I copied two macro examples from the Excel Help File and tried to run them,
but I get an error message that says:


Cannot run the macro €˜MacroName.xlsm. The macro may not be available in
this workbook or all macros may be disabled.

I have enabled all macros. But still get that message.
The macro is in my Personal.xls file in the XLSTART folder. And even when I
open THAT file and try to run the macro, it doesn't work. Same message.

The macros I have copied from Help (there are two) a

Option Explicit
Private Sub App_WorkbookBeforeSave(ByVal Wb As Workbook, _
ByVal SaveAsUI As Boolean, Cancel As Boolean)
a = MsgBox("Do you really want to save the workbook?", vbYesNo)
If a = vbNo Then Cancel = True
End Sub

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)
a = MsgBox("Do you really want to save the workbook?", vbYesNo)
If a = vbNo Then Cancel = True
End Sub


Please help.
Thanks