Dumb Macro Question

Discussion in 'Microsoft Excel Discussion' started by John Gilmer, Jan 21, 2010.

  1. John Gilmer

    John Gilmer Guest

    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
     
    John Gilmer, Jan 21, 2010
    #1
    1. Advertisements

  2. 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
     
    Bernard Liengme, Jan 21, 2010
    #2
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.