Dumb Macro Question

  • Thread starter Thread starter John Gilmer
  • Start date Start date
J

John Gilmer

I have (several times) successfully recorded a macro.

What I want is for the macro to be stored as part of the Excel file so that
when I close the file the macro is inside it and when I open the file again,
the macro is available.

I think I am doing everything right but when I re-open the file the macro is
GONE.

So what should I do to cause a recorded macro to be stored with the
currently open file?

Thanks
 
1) When you start the Record Macro dialog look at the box where you state if
the macro is to be stored in the workbook or in Personal.xls (or
personal.xlb with Excel 2070+)

2) Go to Visual Basic Editor and make sure the code is in the Module for
your workbook

3) If you have Excel 2007: ensure that you save a macro-enabled workbook;
the extension will be XLSM

best wishes
 
Back
Top