+ Reply to Thread
Results 1 to 1 of 1

changing pivot tables - vba code for an event

  1. #1
    Registered User
    Join Date
    09-02-2008
    Location
    poland
    Posts
    1

    changing pivot tables - vba code for an event

    Hi!
    the situation:
    i wrote a code that creates new pivot table whenever user clicks the correct button. I would like to modify some properties so the pivot chart would look nice (changing chart type for 1 of the series and keeping rest untouched). Unfortunately, whenever i do some changes, they disappear after the user takes any action. I tried the following to solve the problem:
    1. defaulting chart type for the desired series, unfortunately it's the solution i would call "all or none". I can't change one of the series and keep other untouched at the same time.
    2. creating a code that is realized whenever specific action (like clicking) is performed on the chart, the problem is that the name of the sheet changes all the time (the pivot table is recreated frequently). I cant write a code for a chart that does not exist (but will be created in the future).
    3. creating a simple macro that do everything i want, it unfortunately needs user to activate it manualy all the time

    question:
    i think that the solution number 2 is the correct one, what should i do to make it work? how can i write a code for an event if the chart will be created later?

    i use excel 2000
    Last edited by reco; 09-02-2008 at 04:19 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 : Viewing different Pivot Tables
    By easycapital in forum Excel General
    Replies: 1
    Last Post: 07-07-2008, 03:21 AM
  2. linking excel pivot tables to access 2000
    By nataliem in forum Excel General
    Replies: 8
    Last Post: 10-18-2007, 07:06 PM
  3. New to pivot tables
    By rodeman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-11-2007, 01:56 PM
  4. Pivot tables linked into SQL Database
    By kosciosco in forum Excel General
    Replies: 0
    Last Post: 07-06-2007, 07:20 AM
  5. Auto Refresh Pivot Tables
    By Marcus Hartley in forum Excel General
    Replies: 2
    Last Post: 06-03-2007, 12:49 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1