If you want your addin to appear in the selections for Tools=Addins so the
user doesn't have to browse for it, then you need to save it or copy it to
the Addin Directory. You can find this by running this code
Sub ShowPath()
msgbox Application.LibraryPath
End Sub
for me (demo'd from the immediate window)
? Application.LibraryPath
C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\LIBRARY
as an example.
--
Regards,
Tom Ogilvy
"
VB Office Bruce" wrote in message
...
Hi Ron de Bruin,
I am using Excel 2000 on one computer and Excel 2003 on another. Code
worked fine on 2003- will it work on 2000 version. Understood that
direction
and modified it to run the Macro I created. Again, the code worked
PERFECTLY!!!!!
If I turn it into an Add-In, do I put the code in ThisWorkbook and then
follow the procedure or can I leave it as a module?
Thanks a lot!
"Ron de Bruin" wrote:
Try to run this code first to see if it is working
Sub MenuBar_Item_Item()
Dim MenuItem As CommandBarControl
MenuBar_Item_Item_Delete
Set MenuItem = Application.CommandBars.FindControl(, 30007)
'Tools menu
If MenuItem Is Nothing Then Exit Sub
With MenuItem.Controls.Add(msoControlButton, 1, , , True)
.Caption = "&Ron de Bruin"
.OnAction = ThisWorkbook.Name & "!TestMacro"
.BeginGroup = True
.Tag = "MenuItemTag"
End With
Set MenuItem = Nothing
End Sub
Sub MenuBar_Item_Item_Delete()
Dim MenuItem As CommandBarControl
Set MenuItem =
Application.CommandBars.FindControl(Tag:="MenuItem Tag")
If Not MenuItem Is Nothing Then
MenuItem.Delete
End If
Set MenuItem = Nothing
End Sub
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Ron de Bruin" wrote in message
...
Hi VB Office Bruce
Do you use Excel 2003 ?
--
Regards Ron de Bruin
http://www.rondebruin.nl
"VB Office Bruce" wrote in
message
...
Yes. I saved it as an .xla following the standard cook book
procedures. It
seems that creating a custom toolbar may be an answer and saving that
as an
xla. Where the commands in the toolbar execute the macros. I've
read
several discussions and will experiement. Don't know if that works.
Thanks.
"davesexcel" wrote:
Did you save it as an add-in?
--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=523986