Can I lock the selection in the pivot table?

[Ai_Jun_Zhang]

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.

[Tom Ogilvy]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Mariano B.]

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