How to edit MyAddIn.xlam
 

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

How to edit MyAddIn.xlam
 

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

--
__________________________________
HTH

Bob

"Lasse" wrote in message
...
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

How to edit MyAddIn.xlam
 

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
"Lasse" wrote in message
...
| 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

How to edit MyAddIn.xlam
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Lasse" wrote in message ...
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