Spreadsheet Default Settings

K

Kevin

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
 
D

Dave Peterson

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.
 
Top