Macros and superstrings in excel 2007

Question

Macros

Hi all.
I need to make a button on the excel 2007 panel to run a macro so that the user pokes it and rejoices.

The trouble is that the macro is in the connected setting and is not shown in the list of macros when the button is added.
www.picamatic.com/show/2011/08/30/11/46/7827301_1280x1024.png
How to be?

I have already reviewed everything, I hope for the help of habrousers.

Answer 1

1. In your picture on the left: Settings and Add-ons, select Add-ons and make sure that someone else's homemade add-on is installed.
2. After installing the AddIn, macros from the AddIn will be available for adding.

Answer 2

Full sequence of actions in pictures:
1. An arbitrary macro is created in the new Excel Workbook
img402.imageshack.us/img402/7246/habr01.png
2.… and its contents
are shown img577.imageshack.us/img577/7256/habr02.png
img405. imageshack.us/img405/1828/habr03.png
3. The macro is saved as Excel AddIn
img823.imageshack.us/img823/9817/habr04.png
4. The AddIn installation process is shown (when you click on the Go button, a dialog will open as on the 6th picture, after selecting the desired
AddIn , it will be added to the list (as in the 5th picture ))
5. After that, macros from the add-in become available in the same dialog. The last picture shows how clicking on the button works with the AddIn connected.
img838.imageshack.us/img838/3941/habr07.png
img195.imageshack.us/img195/6714/habr08.png