I have successfully created a toolbar macro which savesas xls to network drive.
template is called "Reinsurance WS.xlt". The macro created is called SaveIR.
I created a toolbar button and assigned this macro to it.
One problem:
When I opened a blank spreadsheet for a different purpose, this macro
appeared on the toolbar.
How do I tie the macro, a toobar button, to the Reinsurance template only?
I do not want it on any other excel.

Thanks in advance,
Bryan

Toolbar and menu customizations are saved in your Excelxx.xlb file and show
up whenever Excel is opened.

Best practice is to not add/customize to the default but to create the
Toolbar just when the workbook is opened.

Then delete it when that workbook is closed.

See Debra Dalgleish's site for instructions by Dave Peterson.

http://www.contextures.on.ca/xlToolbar02.html

I think in your case, ignore the part about saving as an add-in and just
save the code in the one workbook in question.


Gord Dibben MS Excel MVP

On Sun, 5 Apr 2009 11:05:01 -0700, bryan
wrote:

I have successfully created a toolbar macro which savesas xls to network drive.
template is called "Reinsurance WS.xlt". The macro created is called SaveIR.
I created a toolbar button and assigned this macro to it.
One problem:
When I opened a blank spreadsheet for a different purpose, this macro
appeared on the toolbar.
How do I tie the macro, a toobar button, to the Reinsurance template only?
I do not want it on any other excel.

Thanks in advance,
Bryan

So where does my macro 'SaveIR' go? Would it be AAA?
The SaveIR macro saves the worksheet to the network drive to be imported
into an imaging system.

I have done this in Word and have had no issue in creating a toolbar macro
in a template but, Excel is giving me grief!


Thanks,
Bryan

"Gord Dibben" wrote:

Toolbar and menu customizations are saved in your Excelxx.xlb file and show
up whenever Excel is opened.

Best practice is to not add/customize to the default but to create the
Toolbar just when the workbook is opened.

Then delete it when that workbook is closed.

See Debra Dalgleish's site for instructions by Dave Peterson.

http://www.contextures.on.ca/xlToolbar02.html

I think in your case, ignore the part about saving as an add-in and just
save the code in the one workbook in question.


Gord Dibben MS Excel MVP

On Sun, 5 Apr 2009 11:05:01 -0700, bryan
wrote:

I have successfully created a toolbar macro which savesas xls to network drive.
template is called "Reinsurance WS.xlt". The macro created is called SaveIR.
I created a toolbar button and assigned this macro to it.
One problem:
When I opened a blank spreadsheet for a different purpose, this macro
appeared on the toolbar.
How do I tie the macro, a toobar button, to the Reinsurance template only?
I do not want it on any other excel.

Thanks in advance,
Bryan

If just the one macro 'SaveIR" would replace 'AAA" in each instance of the
sample code.


Gord

On Tue, 7 Apr 2009 11:52:11 -0700, bryan
wrote:

So where does my macro 'SaveIR' go? Would it be AAA?
The SaveIR macro saves the worksheet to the network drive to be imported
into an imaging system.

I have done this in Word and have had no issue in creating a toolbar macro
in a template but, Excel is giving me grief!


Thanks,
Bryan

"Gord Dibben" wrote:

Toolbar and menu customizations are saved in your Excelxx.xlb file and show
up whenever Excel is opened.

Best practice is to not add/customize to the default but to create the
Toolbar just when the workbook is opened.

Then delete it when that workbook is closed.

See Debra Dalgleish's site for instructions by Dave Peterson.

http://www.contextures.on.ca/xlToolbar02.html

I think in your case, ignore the part about saving as an add-in and just
save the code in the one workbook in question.


Gord Dibben MS Excel MVP

On Sun, 5 Apr 2009 11:05:01 -0700, bryan
wrote:

I have successfully created a toolbar macro which savesas xls to network drive.
template is called "Reinsurance WS.xlt". The macro created is called SaveIR.
I created a toolbar button and assigned this macro to it.
One problem:
When I opened a blank spreadsheet for a different purpose, this macro
appeared on the toolbar.
How do I tie the macro, a toobar button, to the Reinsurance template only?
I do not want it on any other excel.

Thanks in advance,
Bryan

Works great.
Is it possible to:
1) Locate the floating toolbar on the actual toolbar?
2) Can one use a button image on this?
I've tried but, does not save. Each 'new' ws shows '1 SaveIR' as the caption.

Thanks,
Bryan

"Gord Dibben" wrote:

If just the one macro 'SaveIR" would replace 'AAA" in each instance of the
sample code.


Gord

On Tue, 7 Apr 2009 11:52:11 -0700, bryan
wrote:

So where does my macro 'SaveIR' go? Would it be AAA?
The SaveIR macro saves the worksheet to the network drive to be imported
into an imaging system.

I have done this in Word and have had no issue in creating a toolbar macro
in a template but, Excel is giving me grief!


Thanks,
Bryan

"Gord Dibben" wrote:

Toolbar and menu customizations are saved in your Excelxx.xlb file and show
up whenever Excel is opened.

Best practice is to not add/customize to the default but to create the
Toolbar just when the workbook is opened.

Then delete it when that workbook is closed.

See Debra Dalgleish's site for instructions by Dave Peterson.

http://www.contextures.on.ca/xlToolbar02.html

I think in your case, ignore the part about saving as an add-in and just
save the code in the one workbook in question.


Gord Dibben MS Excel MVP

On Sun, 5 Apr 2009 11:05:01 -0700, bryan
wrote:

I have successfully created a toolbar macro which savesas xls to network drive.
template is called "Reinsurance WS.xlt". The macro created is called SaveIR.
I created a toolbar button and assigned this macro to it.
One problem:
When I opened a blank spreadsheet for a different purpose, this macro
appeared on the toolbar.
How do I tie the macro, a toobar button, to the Reinsurance template only?
I do not want it on any other excel.

Thanks in advance,
Bryan

You want just one button with assigned macro added to an existing Toolbar
with the button image only?


Gord

On Tue, 14 Apr 2009 11:01:01 -0700, bryan
wrote:

Works great.
Is it possible to:
1) Locate the floating toolbar on the actual toolbar?
2) Can one use a button image on this?
I've tried but, does not save. Each 'new' ws shows '1 SaveIR' as the caption.

Thanks,
Bryan

"Gord Dibben" wrote:

If just the one macro 'SaveIR" would replace 'AAA" in each instance of the
sample code.


Gord

On Tue, 7 Apr 2009 11:52:11 -0700, bryan
wrote:

So where does my macro 'SaveIR' go? Would it be AAA?
The SaveIR macro saves the worksheet to the network drive to be imported
into an imaging system.

I have done this in Word and have had no issue in creating a toolbar macro
in a template but, Excel is giving me grief!


Thanks,
Bryan

"Gord Dibben" wrote:

Toolbar and menu customizations are saved in your Excelxx.xlb file and show
up whenever Excel is opened.

Best practice is to not add/customize to the default but to create the
Toolbar just when the workbook is opened.

Then delete it when that workbook is closed.

See Debra Dalgleish's site for instructions by Dave Peterson.

http://www.contextures.on.ca/xlToolbar02.html

I think in your case, ignore the part about saving as an add-in and just
save the code in the one workbook in question.


Gord Dibben MS Excel MVP

On Sun, 5 Apr 2009 11:05:01 -0700, bryan
wrote:

I have successfully created a toolbar macro which savesas xls to network drive.
template is called "Reinsurance WS.xlt". The macro created is called SaveIR.
I created a toolbar button and assigned this macro to it.
One problem:
When I opened a blank spreadsheet for a different purpose, this macro
appeared on the toolbar.
How do I tie the macro, a toobar button, to the Reinsurance template only?
I do not want it on any other excel.

Thanks in advance,
Bryan