Macros Not In Toolbars

[SV]

Greetings,
I'm using Excel 2003 and a while back I posted a request for how to do some
calculations and combining. I got some great suggestions for macros and
implemented them. They work great, too!
So, I assigned them to toolbar buttons and removed most other toolbars and
icons (Very limited application macros) so that when people use that
spreadsheet, they see exactly what they need, nothing more. I posted the
spreadsheet on our shared drive for everyone to use.

Unfortunately, it seems that now, no matter what spreadsheet I open, I get
those toolbar buttons and the ones I removed for that one spreadsheet are
removed on my local Excel. I"m guessing I didn't save the macros as
'accessible only on that spreadsheet' or something, too.

So I have to wonder... how can I make the macros 'button accessible' to
everyone but only on THAT spreadsheet?
Perhaps a way of adding a button to the spreadsheet itself?

Any ideas would be appreciated.

Thanks,
Shane

 

[SV]

Kassie,
Hmm.. well... I didn't use much code beyond a macro to combine the
contents of a given cell. I'm too new to macros to even know what a
'beforeClose event is.
I did, however, customize the toolbars to show the Macros toolbar with two
buttons I created.
The problem seems to be that by customizing my toolbar in that worksheet (to
show the Macros toolbar, with my custom buttons), I made it so Excel always
shows that toolbar, even if those macros don't exist in the new worksheet.

I'm accustomed to Word's template file and being able to make different
templates and link documents to them. With that, I can open up one document
linked to one template and another document linked to another.
I see 'template files' for excel, but I don't see how you link a given
spreadsheet to the template.

Do you know if there's a way to set up Excel's toolbars and save a template
file such that when we open the workbook in the shared directory it shows
the 'special' toolbar, but when we open our own Excel documents it shows our
'usual' toolbars???

Thanks,
Shane

 

[SV]

Kassie,
I do apprecaite the info, I'll take a look and dig in. I don't know much
about them, but I seem to have a knack for at least grasping the more simple
ones!

Shane