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").CurrentPag e = "Admin"

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

Is there any way to do that?


Thanks,

Aijun

--
Ai_Jun_Zhan
-----------------------------------------------------------------------
Ai_Jun_Zhang's Profile: http://www.excelforum.com/member.php...fo&userid=2547
View this thread: http://www.excelforum.com/showthread.php?threadid=47085

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"
wrote in message
news:Ai_Jun_Zhang.1vzcqg_1127761533.5192@excelforu m-nospam.com...

Hi!

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

objMyPivotTable.PivotFields("Category").CurrentPag e = "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

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