+ Reply to Thread
Results 1 to 3 of 3

Can I lock the selection in the pivot table?

  1. #1
    Registered User
    Join Date
    07-21-2005
    Posts
    28

    Can I lock the selection in the pivot table?

    Hi!

    I have set in my code (vba) for a page field as

    objMyPivotTable.PivotFields("Category").CurrentPage = "Admin"

    I would like this page field to be locked. That is user can not make selection for the Category field any more.

    Is there any way to do that?


    Thanks,

    Aijun.

  2. #2
    Tom Ogilvy
    Guest

    Re: Can I lock the selection in the pivot table?

    Why not sort the source data on "Category" and build this table only from
    the data with a Category of Admin (You probably will need to insert rows
    between categories and copy the header row to each category.

    --
    Regards,
    Tom Ogilvy


    "Ai_Jun_Zhang" <Ai_Jun_Zhang.1vzcqg_1127761533.5192@excelforum-nospam.com>
    wrote in message
    news:Ai_Jun_Zhang.1vzcqg_1127761533.5192@excelforum-nospam.com...
    >
    > Hi!
    >
    > I have set in my code (vba) for a page field as
    >
    > objMyPivotTable.PivotFields("Category").CurrentPage = "Admin"
    >
    > I would like this page field to be locked. That is user can not make
    > selection for the Category field any more.
    >
    > Is there any way to do that?
    >
    >
    > Thanks,
    >
    > Aijun.
    >
    >
    > --
    > Ai_Jun_Zhang
    > ------------------------------------------------------------------------
    > Ai_Jun_Zhang's Profile:

    http://www.excelforum.com/member.php...o&userid=25474
    > View this thread: http://www.excelforum.com/showthread...hreadid=470857
    >




  3. #3
    Mariano B.
    Guest

    Re: Can I lock the selection in the pivot table?

    I am also in sort of the same situation. I need to lock teh column and row
    fields from my pivot table. The data in the original table cannot be sorted
    to the variables i need in this table as it is already sorted according to
    some other criteria.

    Any ideas??

    --
    Mariano


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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