Macro Dialog Box Drop Down Options

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

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

Similar Threads

Select drop down menu option using libre-calc macro 0
alt down arrow shortcut not working 0
Drop down list and macros? 1
How to link macro to change an item in drop-down list 1
Pasting cell contents into a macro 1
Assign Macro Dialog Box 6
Recording new Macro won't reset drop downs 3
Create Drop Down List of Macros 1

Back
Top