You can set up a default workbook which should be saved as a Template to your XLStart folder and named Book.xlt. All new workbooks you open will default to that format.
If you wish to have macros available to all open workbooks, store them in a file called Personal.xls also in your XLStart folder.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.