Can't add macro to Quick Access Toolbar

[Bagharmin]

I manually added a module to my Personal.XLS workbook and was going to add it to the Quick Access Toolbar (Excel 2010 on Windows 7), but Excel doesn't show it as one of the available macros. I can see it (called "Pricing") plain as day in the project window and I'm looking at the code, but it isn't listed in the box Excel gives you when you select "Macros" in the "Choose commands from:" box.

I looked and I only have the one Personal.XLS file (in the XLSTART folder). I've worked on this for a few days now, so it's been saved and Excel has been closed and opened several times.

What do I need to do to make it an available macro in Excel?

Thanks.

 

[JoeMo]

In Excel 2010 the personal workbook is usually "PERSONAL.XLSB", but assuming your personal workbook uses a .XLS extension, does your module possibly begin with "Private", i.e Private Sub Pricing() ?? If yes, you'll need to remove the Private label before you can assign it to the QAT.

 

[Bagharmin]

Thank you very much. That took care of it. I'll definitely remember that going forward.