Hi Dave,

I was using View etc. in VB, but I should use the EXCEL tab. Now it's
working, thanks.

"Dave Peterson" wrote in message
...
I think you missed Jim's "Tools Category" reference.

View|toolbars|Commands Tab|Tools Category|COM Add-ins... (about half way
down)

Drag it to your favorite toolbar. (I put mine right below Tools|Addins)


Gerrit van Stempvoort wrote:

Hello Jim,

I have more or less the same problem as Vikram.
In my VB Menu bar is a option Add-Ins. If I click that option I got an
Add-In Manager showing a empty box of available Add-Ins and no option to
ad
one.
When I follow your suggestion ViewToolbarsCommands I see in the
command
column an function "Additional Controls". However, when I drag that one
to
the Menu bar it is not possible to activate it.
How can I made this function active? I'm using Office 2000 (which is
different from older versions on this point, according to the help file)
and
VB 6.3.

"Vikram Kohli" wrote in message
...

Hi jim

There is no command as COM Add-In when i have selected Tools category
in
Visual Basic.

----- Jim Rech wrote: -----

The loading of standard Excel add-ins is controlled through
Tools,
Add-ins.
If this is a COM Add-in its loading is controlled through Tools,
COM
Add-ins. That menu item is not visible by default in Excel. To
add
it to
your menu you have to go into View, Toolbars, Customize. Go to
the
Commands
tab and the Tools category. You'll find COM Add-ins in the list
of
commands. All you have to do is drag it to your Tools menu.

--
Jim Rech
Excel MVP
"Vikram Kohli" wrote in message
...
| Hi,
|
| I have created Excel an AddIn in VB and i wish to load it when
my
program
opens excel. What is the code that i have to write for that. I
have
already
set the startup option in addin to "Load On Demand". Plz.. Help
|
| Thanks
|
| Vikram Kohli




--

Dave Peterson