Dumb Macro Question

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top