How to edit MyAddIn.xlam

[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

 

[Bob Phillips]

Go to the VBIDE, Alt-F11, open up the addin project and add the code. Save
the project in the VBIDE.

 

[Jim Rech]

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

 

[Ron de Bruin]

Hi Lasse

See also
http://www.rondebruin.nl/qat.htm

You can click the Edit Menu option in the menu
And use alt-F11 to edit your macros