Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Default Gridline Print in Excel
- Thread starter jhruby
- Start date
SkipVought
Programmer
Hi,
No way to set a default like this.
However, you could record a macro that sets the gridlines and call the macro from the Workbook_BeforePrint event in the VB Editor (alt-F11 -- select the WORKBOOK object in the Project Explorer ctr+R -- paste the following
Assuming that your macro is named, SetTheGrid
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
Skip,
No way to set a default like this.
However, you could record a macro that sets the gridlines and call the macro from the Workbook_BeforePrint event in the VB Editor (alt-F11 -- select the WORKBOOK object in the Project Explorer ctr+R -- paste the following
Code:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
SetTheGrid
End SubWant to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
Skip,
- Status