LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Code to maintain formatting

There's not a lot of help out there for working with pivot
tables, but my boss insists that this is the way to go.
So here I am trying to make it work.

I want to write a macro to automate the "show pages"
feature. I have two needs.

1. Is there some code I can use to maintain formatting of
the pivot table when it generates the other pages.

2. Is it possible to use code to delete those pages when
I'm through with them?

I haven't used VB in a few years, so I'm having to relearn
it as I go along.

Thanks for your help.

p.s. Why is there not a pivot table group? Is it because
you are so limited with them that nobody uses them?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maintain Formatting with Formulas Jacob Dieter Excel Discussion (Misc queries) 1 January 18th 10 04:30 AM
Maintain formatting in linked chart title chumley Charts and Charting in Excel 1 May 15th 07 07:07 PM
Maintain pivot table formatting after refresh dan Excel Discussion (Misc queries) 0 January 10th 07 03:09 PM
How do I copy and paste a worksheet and maintain all formatting? jana Excel Worksheet Functions 2 September 19th 06 10:08 PM
How can I sort and maintain formatting? littlelostgrl Excel Discussion (Misc queries) 2 August 24th 05 08:11 PM


All times are GMT +1. The time now is 04:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"