| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Options at Start up
How do I automatically stop Zero Values & Gridlines showing as default.
I know how to do it manually, but not how to set as default. Can anyone help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Options at Start up
Both of those setting are sheet settings, not application settings. So the
short answer is that there is no easy way to do what you are asking. You could potentially write an Addin with VBA to do what you want but I would not necessarily recommend it as a project for a first timer... If you wnat to try writing the addin I could point you in the general direction you want to go and give you a couple of pointers... -- HTH... Jim Thomlinson "Sean" wrote: How do I automatically stop Zero Values & Gridlines showing as default. I know how to do it manually, but not how to set as default. Can anyone help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Options at Start up
it would be very helpful.
Sean... "Jim Thomlinson" wrote: Both of those setting are sheet settings, not application settings. So the short answer is that there is no easy way to do what you are asking. You could potentially write an Addin with VBA to do what you want but I would not necessarily recommend it as a project for a first timer... If you wnat to try writing the addin I could point you in the general direction you want to go and give you a couple of pointers... -- HTH... Jim Thomlinson "Sean" wrote: How do I automatically stop Zero Values & Gridlines showing as default. I know how to do it manually, but not how to set as default. Can anyone help |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Options at Start up
Jim
On the contrary Do two things 1) Set each worksheet in a new workbook (default is 3) with your settings and save the workbook as book.xlt (Excel template) to your xlStart folder (Usually C:\Documents and Settings\%UserName%\Application Data\Microsoft\Excel\xlStart (May be hidden)) 2) Open a workbook and delete all but one sheet, save this as a template called sheet.xlt to the same folder The first will set what a new workbook looks like and the second determines how sheets added to an existing workbook look -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Jim Thomlinson" wrote in message ... Both of those setting are sheet settings, not application settings. So the short answer is that there is no easy way to do what you are asking. You could potentially write an Addin with VBA to do what you want but I would not necessarily recommend it as a project for a first timer... If you wnat to try writing the addin I could point you in the general direction you want to go and give you a couple of pointers... -- HTH... Jim Thomlinson "Sean" wrote: How do I automatically stop Zero Values & Gridlines showing as default. I know how to do it manually, but not how to set as default. Can anyone help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel loading on start up | Excel Discussion (Misc queries) | |||
| 7 day workweek timesheet - excluding lunch | Excel Worksheet Functions | |||
| random start and calculation | Excel Worksheet Functions | |||
| Start spreadsheet with WinXP start | Excel Worksheet Functions | |||
| Help! Excel 2000 fully SP'ed will not start | Excel Discussion (Misc queries) | |||
Linear Mode
