![]() |
Spreadsheet Default Settings
Hello
I would like to adjust my default settings for excel sheet such that whenever I open a new sheet it has as default the file path of spreadsheet whenever it is printed out. Also I would like that gridlines do not show (ie Tools, Options, Display gridlines = No) I am certain this can be done in VB but cnanot remember how - any help appreciated -- Kevin |
Spreadsheet Default Settings
Start a new workbook--single sheet only
Set up the footer and gridlines the way you want. Save that workbook as a template in your XLStart folder. Name it sheet.xlt. Then try it out. Kevin wrote: Hello I would like to adjust my default settings for excel sheet such that whenever I open a new sheet it has as default the file path of spreadsheet whenever it is printed out. Also I would like that gridlines do not show (ie Tools, Options, Display gridlines = No) I am certain this can be done in VB but cnanot remember how - any help appreciated -- Kevin -- Dave Peterson |
All times are GMT +1. The time now is 06:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com