I received the excelTip today on how to add a style box to the toolbar,
then adding wrap text to the style box. Works great, but...

the wrap text is gone when you open a new worksheet. This would be
much better if you could keep it available for every instance of excel.
I tried putting this in the personal.xls file, because that is always
open, but that didn't work either. Is their a fix? - or did I do
something wrong?


--
justme2
------------------------------------------------------------------------
justme2's Profile: http://www.excelforum.com/member.php...o&userid=30357
View this thread: http://www.excelforum.com/showthread...hreadid=500143

You'd need to put those preferences into the templates that Excel uses for
new workbooks and new sheets.

Per Excel help:
Storing default workbook and worksheet templates
If you've created a template named Book.xlt or Sheet.xlt and saved it in the
XLStart folder, Microsoft Excel uses the template to create new default
workbooks or to insert new worksheets. The XLStart folder is usually located
at:

C:\Program Files\Microsoft Office\Office10\XLStart


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"justme2" wrote:


I received the excelTip today on how to add a style box to the toolbar,
then adding wrap text to the style box. Works great, but...

the wrap text is gone when you open a new worksheet. This would be
much better if you could keep it available for every instance of excel.
I tried putting this in the personal.xls file, because that is always
open, but that didn't work either. Is their a fix? - or did I do
something wrong?


--
justme2
------------------------------------------------------------------------
justme2's Profile: http://www.excelforum.com/member.php...o&userid=30357
View this thread: http://www.excelforum.com/showthread...hreadid=500143