Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In Question
I have createed an AddIn following the steps outlined here http://tinyurl.com/genql. So I have an addin *.xla file. I have successfully added it through Tools -- Addin, and checked the box next to my Addin's name. However when I try to fire the macro in the Addin via Tools, Macro, Macros, nothing appears in the Macro box. I renamed Module1 to MainModule and put my public function there, but I don't think that would cause it. Any idea what I did wrong? (Excel 2000, Addin written in Excell 2000 VBa enviroment) -- Fountainhead ------------------------------------------------------------------------ Fountainhead's Profile: http://www.excelforum.com/member.php...o&userid=32825 View this thread: http://www.excelforum.com/showthread...hreadid=526302 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In Question
You won't see it. Press <Alt<F8, and in the macro box type in the name.
It will run "Fountainhead" wrote: I have createed an AddIn following the steps outlined here http://tinyurl.com/genql. So I have an addin *.xla file. I have successfully added it through Tools -- Addin, and checked the box next to my Addin's name. However when I try to fire the macro in the Addin via Tools, Macro, Macros, nothing appears in the Macro box. I renamed Module1 to MainModule and put my public function there, but I don't think that would cause it. Any idea what I did wrong? (Excel 2000, Addin written in Excell 2000 VBa enviroment) -- Fountainhead ------------------------------------------------------------------------ Fountainhead's Profile: http://www.excelforum.com/member.php...o&userid=32825 View this thread: http://www.excelforum.com/showthread...hreadid=526302 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In Question
The add-in will have to make a menu to access the routines in that add-in.
Type in Google: Add-in Excel tutorial And it all will be explained nicely. RBS "Fountainhead" wrote in message ... I have createed an AddIn following the steps outlined here http://tinyurl.com/genql. So I have an addin *.xla file. I have successfully added it through Tools -- Addin, and checked the box next to my Addin's name. However when I try to fire the macro in the Addin via Tools, Macro, Macros, nothing appears in the Macro box. I renamed Module1 to MainModule and put my public function there, but I don't think that would cause it. Any idea what I did wrong? (Excel 2000, Addin written in Excell 2000 VBa enviroment) -- Fountainhead ------------------------------------------------------------------------ Fountainhead's Profile: http://www.excelforum.com/member.php...o&userid=32825 View this thread: http://www.excelforum.com/showthread...hreadid=526302 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In Question
Macros in add-ins aren't shown in the macro dialog box. When you
write an add-in you need to also write the user interface for the add-in, typically menu items or a command bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Fountainhead" wrote in message ... I have createed an AddIn following the steps outlined here http://tinyurl.com/genql. So I have an addin *.xla file. I have successfully added it through Tools -- Addin, and checked the box next to my Addin's name. However when I try to fire the macro in the Addin via Tools, Macro, Macros, nothing appears in the Macro box. I renamed Module1 to MainModule and put my public function there, but I don't think that would cause it. Any idea what I did wrong? (Excel 2000, Addin written in Excell 2000 VBa enviroment) -- Fountainhead ------------------------------------------------------------------------ Fountainhead's Profile: http://www.excelforum.com/member.php...o&userid=32825 View this thread: http://www.excelforum.com/showthread...hreadid=526302 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|