Toolbar macros

[TMAC]

I thought I posted this but couldn't find it again.. so
here it is again (maybe)

1) I copied the macros to the myworkbook module. That
solved the buttons running the macros after the sheet was
saved to a different name.

2) I also had a sugesstion to make the toolbars when the
sheet opened by using the commandbar vbe but not quite
sure how to do this.

I have the toolbars made. Is there a way to access the
code for these toolbars so I don't have to learn the code
and re-create the toolbars. Would like to cut and past if
possible.

Or a way to do Me!macroname.....

thanks

tim

 

[Tom Ogilvy]

You posted it

1 response:
Hi TMAC;

Yes;

You can put an auto_open macro in the workbook and have it
build a menu each time it opens. One of the options when
you do this is to have the menu be temporary which means
it will automatically not be there the next time Excel is
opened.

You can find out how to do this by looking in the VBA help
under commandbars

Thanks,

Greg

 

[TMAC]

Yes. I saw this one. Thats why im asking #2 and the cut
and past question... Pasted below.... Any Ideas???
thanks.... tim... btw, can I get this in a newsgroup
reader such as express? Im using the web based form which
makes it harder to keep track....

 

[Tom Ogilvy]

no, you can't get the "code" for the toolbars unless you turned on the macro
recorder while you created them. You can't do it after the fact.


Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm

http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&Product=xlw
How to customize menus and menu bars in Excel


http://support.microsoft.com/default.aspx?scid=kb;en-us;166755
File Title: Customizing Menu Bars, Menus, and Menu Items in Microsoft(R)
Excel 97
File Name: WE1183.EXE
File Size: 58041 bytes
File Date: 06/20/97
Keywords: kbfile kbappnote
Description: This Application Note can help you learn techniques for writing
Visual Basic(R) for Applications code to customize menus in Microsoft Excel
97. This Application Note contains code examples that you can use with the
following elements: menu bars, menus, menu items, submenus, and shortcut
menus.

 

[Microsoft Community]

thanks...... these should help alot!!!!!!

no, you can't get the "code" for the toolbars unless you turned on the macro
recorder while you created them. You can't do it after the fact.


Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm

http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&Product=xlw
How to customize menus and menu bars in Excel


http://support.microsoft.com/default.aspx?scid=kb;en-us;166755
File Title: Customizing Menu Bars, Menus, and Menu Items in Microsoft(R)
Excel 97
File Name: WE1183.EXE
File Size: 58041 bytes
File Date: 06/20/97
Keywords: kbfile kbappnote
Description: This Application Note can help you learn techniques for writing
Visual Basic(R) for Applications code to customize menus in Microsoft Excel
97. This Application Note contains code examples that you can use with the
following elements: menu bars, menus, menu items, submenus, and shortcut
menus.