Excel should let me set print gridlines as a default

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peg B - 15 Jun 2006 20:55 GMT

I want gridlines to print on nearly every Excel worksheet so want to make it
a default option.

Reply to this Message

Don Guillett - 15 Jun 2006 23:17 GMT

right click the excel icon on the left of the title bar just to the left of
File>insert this>save

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.PrintGridlines = True
End Sub

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I want gridlines to print on nearly every Excel worksheet so want to make
>it
[quoted text clipped - 9 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=18f1aeb7-b0f7-4
3c3-9bcc-adf1fdb0b674&dg=microsoft.public.excel.worksheet.functions

Reply to this Message