Macro Dialog Box Drop Down Options

E

EC

I was just posed a question regarding the drop-down list in the Macro Dialog Box. Apparently, a previous user customized this list to include his own macros. I'm refering to the "Macros In" drop down box you get when selecting "Tools", "Macro", then "Macros" in Excel 2003. Anyhow, this person wants to know how to have the same thing happen on her laptop as happens on her "inherited" desktop and have this database of macros available from the drop down menu. Does anyone out there have any clue how this is done?
 
G

Gord Dibben

EC

The macros could be in each workbook.......OR......

The macros are most likely in a Personal.xls file, which is commonly used to
store macros available to all open workbooks.

This file is stored in the Office\XLSTART folder.

It opens "Hidden" when Excel starts up.

Have the user do a search on the inherited desktop computer for Personal.xls

Copy this file to her Laptop

Gord Dibben Excel MVP
 
Top