Desert Piranha
11-16-2005, 03:34 PM
Hi all,
While not a VBA question, it is excel, so i thought i may get some input.
I have customized my Book.xlt the way i want it. It opens with Excel just the way it should. No problem. Its in:
C:\Documents and Settings\Owner\Application Data\Microsoft\Excel\XLSTART
There are NO other Book.xlt files on my system.
There are NO files in:
C:\Program Files\Microsoft Office\Office\XLStart
There are no other XLStart folders on my system.
Problem: When i open Excel a "Book1" opens, with format just like i want it, if however i insert sheets they are NOT in the customized format. They are in the old default format.
Question: What is the source of "insert sheets"?? So i can change the source. I figure it the insert sheets is comming from a template folder but i cannot identify the source file.
Thx
While not a VBA question, it is excel, so i thought i may get some input.
I have customized my Book.xlt the way i want it. It opens with Excel just the way it should. No problem. Its in:
C:\Documents and Settings\Owner\Application Data\Microsoft\Excel\XLSTART
There are NO other Book.xlt files on my system.
There are NO files in:
C:\Program Files\Microsoft Office\Office\XLStart
There are no other XLStart folders on my system.
Problem: When i open Excel a "Book1" opens, with format just like i want it, if however i insert sheets they are NOT in the customized format. They are in the old default format.
Question: What is the source of "insert sheets"?? So i can change the source. I figure it the insert sheets is comming from a template folder but i cannot identify the source file.
Thx