ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Spreadsheet Default Settings (https://www.excelbanter.com/excel-discussion-misc-queries/73476-spreadsheet-default-settings.html)

Kevin

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

Dave Peterson

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