| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gridlines have to be chosen each time
It seems to me it used to be that gridlines were the default when printing. I
don't remember always having to choose "sheet" tab and click the "gridlines" checkbox. I tried to set up XLSTART to have that be chosen automatically, but it didn't work. How can I have gridlines on every sheet without having to choose it when printing? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Gridlines have to be chosen each time
One way would be to put this in the ThisWorkbook module
Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.PrintGridlines = True End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "jknapp1005" wrote in message ... It seems to me it used to be that gridlines were the default when printing. I don't remember always having to choose "sheet" tab and click the "gridlines" checkbox. I tried to set up XLSTART to have that be chosen automatically, but it didn't work. How can I have gridlines on every sheet without having to choose it when printing? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Font different than one chosen | Excel Discussion (Misc queries) | |||
| Row colors overlay the gridlines...how do I show gridlines? | Excel Discussion (Misc queries) | |||
| In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- | New Users to Excel | |||
| Can't change gridlines colour a second time | Charts and Charting in Excel | |||
| How do I let only one box be chosen when there are several? | Excel Worksheet Functions | |||
Hybrid Mode
