Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grid Lines vs. Borders
Hello.
Does anyone know if it's possible in Excel XP using VBA to code a sheet so that the grid lines print very faint without altering black borders (used for pseudo underlining)? If not, is there a way to make an underline appear all the way across a cell to make it look like a border - even blank cells? Your example code would be most helpful in either case. Thanks in advance for your assistance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grid Lines vs. Borders
The folloing does the firs row. You could do them all by
changing the range for the select but remember if you put the underline in it will print even if there is no data. So if you were to do this for all lines then you would print down to 65656. Sub try() Rows("1:1").Select Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone Selection.Borders(xlEdgeLeft).LineStyle = xlNone Selection.Borders(xlEdgeTop).LineStyle = xlNone With Selection.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With Selection.Borders(xlEdgeRight).LineStyle = xlNone Selection.Borders(xlInsideVertical).LineStyle = xlNone End Sub -----Original Message----- Hello. Does anyone know if it's possible in Excel XP using VBA to code a sheet so that the grid lines print very faint without altering black borders (used for pseudo underlining)? If not, is there a way to make an underline appear all the way across a cell to make it look like a border - even blank cells? Your example code would be most helpful in either case. Thanks in advance for your assistance. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel- printing borders (not grid lines) | Excel Discussion (Misc queries) | |||
Can't print only borders. I want a grid sheet no words | Excel Discussion (Misc queries) | |||
Printing with grid lines or borders - problem | Excel Discussion (Misc queries) | |||
Grid lines in Excel not showing.Have tools,options,view/grid cked | Excel Discussion (Misc queries) | |||
printing grid lines when grid lines is checked | Setting up and Configuration of Excel |