Murray

How did you open a new workbook?

The workbook you get with FileNewBlank Workbook is not based on the
changecase Template.

Try opening a new workbook through FileNew...TemplatesOn my Computer.

Browse to your changecase template and open it.

It will open as changecase1.xls and you macros will be available.

I would save the workbook as an add-in and load it through ToolsAdd-ins.

Any macros you place in that add-in will be available for any open workbook.


Gord Dibben Excel MVP


On Tue, 6 Dec 2005 12:48:02 -0800, Murray
wrote:

-I saved the workbook as a template, changecase.xlt, in
C:\Documents and Settings\me\Application Data\Microsoft\Templates
-I opened a new workbook and the custom toolbar was there