I have created an excel workbook where the only toolbar displayed is one
which I have created. I have attached this toolbar to the workbook already.
However, my question is when I close this workbook and open a completly new
Excel workbook, it has kept those original settings from the previous
workbook.
All the custom toolbars, Formula, Standard etc remain hidden.

How can I change this so that only my created workbook keeps my personal
settings

Any help for a novice???
thanks in advance
Anthony

Anthony

You can create menu items and Toolbars for each workbook "on the fly" by using
code to build the items when the workbook opens or is activated and deleted
upon the reverse.

I think this is the way you should go.

For more on this see

http://support.microsoft.com/default...b;EN-US;830502

http://support.microsoft.com/support.../Q159/6/19.asp

http://support.microsoft.com/default...EN-US;Q166755&

For info on "attaching" toolbars to a workbook see

http://www.microsoft.com/exceldev/articles/toolbatt.htm


Gord Dibben Excel MVP

On Fri, 25 Feb 2005 15:29:04 -0800, "Anthony"
wrote:

I have created an excel workbook where the only toolbar displayed is one
which I have created. I have attached this toolbar to the workbook already.
However, my question is when I close this workbook and open a completly new
Excel workbook, it has kept those original settings from the previous
workbook.
All the custom toolbars, Formula, Standard etc remain hidden.

How can I change this so that only my created workbook keeps my personal
settings

Any help for a novice???
thanks in advance
Anthony