| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Page Setup Defaults
Hi,
I suppose you could add a vba routine to each users Personal.xls file (the personal macro workbook. You would add an event macro to the thisWorkbook object. The code would be: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.PrintGridlines = True End Sub I believe this will work. -- Thanks, Shane Devenshire "AFD at FONO" wrote: Is it possible to set the default for page setup so that grid lines are always printed? Similarly can you reset the default margins. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Page layout - page setup - items disabled | Excel Discussion (Misc queries) | |||
| editing setup defaults | Setting up and Configuration of Excel | |||
| HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE | Excel Worksheet Functions | |||
| How do I change the defaults for Page Setup in Excel? | Excel Discussion (Misc queries) | |||
| Is there a way to apply "page setup" defaults to an existing work. | Excel Discussion (Misc queries) | |||
Threaded Mode
