Toolbar macros
 

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

Toolbar macros
 

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

--
Regards,
Tom Ogilvy


"TMAC" wrote in message
...
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

Toolbar macros
 

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....

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.....



-----Original Message-----
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

--
Regards,
Tom Ogilvy


"TMAC" wrote in
message
...
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


.

Toolbar macros
 

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...02&Product=xlw
How to customize menus and menu bars in Excel


http://support.microsoft.com/default...b;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.

--
Regards,
Tom Ogilvy

"TMAC" wrote in message
...
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....

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.....



-----Original Message-----
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

--
Regards,
Tom Ogilvy


"TMAC" wrote in
message
...
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


.

Toolbar macros
 

thanks...... these should help alot!!!!!!
"Tom Ogilvy" wrote in message
...
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...02&Product=xlw
How to customize menus and menu bars in Excel


http://support.microsoft.com/default...b;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.

--
Regards,
Tom Ogilvy

"TMAC" wrote in message
...
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....

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.....



-----Original Message-----
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

--
Regards,
Tom Ogilvy


"TMAC" wrote in
message
...
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


.