Remove Pivot Table Borders with Macro

B

BJ

Hello I need to remove the borders from pivot tables. I read recently that
with Excel 2003 borders cannot be formatted in a pivot table as the refresh
function will change them. I need a macro to remove the borders. Any help
would be appreciated. Thanks.

BJ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Macro to Format Multiple Sheets based on "Master" Format 0
Vertical short line in front of word 0
Excel does not accept text format! 0
Macro to copy table of contents to a new doc 0
Pivot Table Question 2
Pivot Table Management 4
Border formatting row of cells 22

Top