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