Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Hi,
    I swear I've been able to do this before, but now I'm having issues. I don't want my pivot table to look like a pivot table, so I don't want any lines. I make sure I "select the entire pivottable" option, then click on the border icon that has no lines. It clears out all the line formatting, but then I refresh the pivot table, and some of the lines (the shape looks like a "t") come back. How can I get rid of the line formatting for good?
    Thanks!
    Lana

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can use the PivotTableUpdate event of the worksheet. Right-click the sheet tab and copy/paste the following code.

    Code:
    Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
      With Target.TableRange2
    	.Borders(xlEdgeTop).LineStyle = xlLineStyleNone
    	.Borders(xlEdgeRight).LineStyle = xlLineStyleNone
    	.Borders(xlEdgeBottom).LineStyle = xlLineStyleNone
    	.Borders(xlEdgeLeft).LineStyle = xlLineStyleNone
    	.Borders(xlInsideHorizontal).LineStyle = xlLineStyleNone
    	.Borders(xlInsideVertical).LineStyle = xlLineStyleNone
      End With
    End Sub

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts
    I love it... thanks Hans!!
    Lana

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •