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