Macros and Add-Ins

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

Using Excel 2002

1. I will create a macro, and assign it an icon on the toolbar. It works
great until I close Excel. I will open Excel enter data and click on the
icon/macro to run it. Nothing happens. I have to re-create the macro
again, and then it will work. What's happening?

2. I have most add-ins checked, but they don't show-up on the menu bar. I
have to uncheck the add-ins and recheck them in the add-in box, then the
add-ins are visible on the menu bar. Close excel, open and no add-ins until
I check and uncheck them in the add-in box. What's happening?

Thanks, in advance...

Anthony
 
Correction, the last line should of read:
"I uncheck and check them in the add-in box...."
A
 
You could put your macro in the personal.xls and then attach the macro to
the button.
Otherwise the macro will remain in the workbook it was created in
 
Anthony

In-line comments..........

Using Excel 2002

1. I will create a macro, and assign it an icon on the toolbar. It works
great until I close Excel. I will open Excel enter data and click on the
icon/macro to run it. Nothing happens. I have to re-create the macro
again, and then it will work. What's happening?
Click to expand...

Where are you creating and storing the macro? Current active workbook?
Personal.xls? Add-in? Each can have their own particular storage folder.
2. I have most add-ins checked, but they don't show-up on the menu bar. I
have to uncheck the add-ins and recheck them in the add-in box, then the
add-ins are visible on the menu bar. Close excel, open and no add-ins until
I check and uncheck them in the add-in box. What's happening?
Click to expand...

Checked Add-ins settings are written to the Registry. Perhaps this is not
being done on your machine due to permissions settings.

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options

Open, Open1, Open2 etc.

After you check the Add-ins you want to be available, close Excel and drill
down to Options in the Registry using the path above.

Are these Keys listed? If not, you have some sort of problem with permissions
for Excel to write to the Registry. Perhaps a User Permission problem. Can
you set yourself up as Administrator with full permissions?

Gord Dibben Excel MVP
 
Peo and Gord:

Thanks for the help. It looks like the macro is in the workbook. I tinker
some more since I have a direction now to go.

Add-inns - Could be the registry, I'll check and see.

This on my work computer. Being Friday night, it will be a few days before
I can look into it...

Anthony
 
Back
Top