How to edit MyAddIn.xlam

  • Thread starter Thread starter Lasse
  • Start date Start date
L

Lasse

Hi

I am new to Excel 2007 and the use of add-ins. I have a Personal.xlsb and I
have created MyAddIn.xlam which only purpose is to add some macros to the
Quick Access Toolbar, this works fine, when opening Excel 2007 it add's the
macros to the QAT through the add-in. BUT now I would like to add a macro the
QAT but can't figure out how I actually can edit MyAddIn.xlam?

/Lasse
 
Go to the VBIDE, Alt-F11, open up the addin project and add the code. Save
the project in the VBIDE.
 
If the add-in is open go to the VBE (Alt-F11) and you should be able to find
its code there. After making changes you can save the add-in from the VBE.

Just to clarify something you said. And add-in does not "add some macros to
the QAT". An add-in merely contains the macros. To run them from the QAT
you have to manually connect a QAT button to them, through the QAT Customize
command.

--
Jim
| Hi
|
| I am new to Excel 2007 and the use of add-ins. I have a Personal.xlsb and
I
| have created MyAddIn.xlam which only purpose is to add some macros to the
| Quick Access Toolbar, this works fine, when opening Excel 2007 it add's
the
| macros to the QAT through the add-in. BUT now I would like to add a macro
the
| QAT but can't figure out how I actually can edit MyAddIn.xlam?
|
| /Lasse
 
Back
Top