Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Default Excel Template 1
- Thread starter uxo22
- Start date
-
1
- #2
As explained in
If you have templates called Book.xlt and Sheet.xlt in the XLStart directory, they should provide the default settings without the need for VBA or macros at all. If the book does not already exist, just set page setup as required in a blank work book, and any other default settings you might want, and save it as Book.xlt in the XLStart folder (typically ..\Microsoft Office\Office\XLStart\.
Remember to apply the same settings to each worksheet. Then also save one of those sheets as Sheet.xlt, also in the XLStart folder.
All new workbooks you create after saving these file should adopt all the properties of Book.xlt, including page setup. The same setup will apply for any new worksheets you insert in any workbook, new or old.
Kieran
If you have templates called Book.xlt and Sheet.xlt in the XLStart directory, they should provide the default settings without the need for VBA or macros at all. If the book does not already exist, just set page setup as required in a blank work book, and any other default settings you might want, and save it as Book.xlt in the XLStart folder (typically ..\Microsoft Office\Office\XLStart\.
Remember to apply the same settings to each worksheet. Then also save one of those sheets as Sheet.xlt, also in the XLStart folder.
All new workbooks you create after saving these file should adopt all the properties of Book.xlt, including page setup. The same setup will apply for any new worksheets you insert in any workbook, new or old.
Kieran
- Status