| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating spreadsheet of Outlook emails | Excel Discussion (Misc queries) | |||
| Change default import settings | Excel Discussion (Misc queries) | |||
| Applying Existing Password to New Spreadsheet | Excel Discussion (Misc queries) | |||
| how do I make excel 2003 my default spreadsheet over ms works spr. | Setting up and Configuration of Excel | |||
| How do I change the default settings in charts? | Charts and Charting in Excel | |||
Linear Mode
