Can I lock the selection in the pivot table?  
Author Message
marksuza





PostPosted: Mon Sep 26 14:16:35 CDT 2005 Top

Excel Programming >> 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 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.hide-link.com/ ;userid=2547
View this thread: http://www.hide-link.com/

Excel229  
 
 
Tom





PostPosted: Mon Sep 26 14:16:35 CDT 2005 Top

Excel Programming >> 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





>
> 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?action=getinfo&userid=25474
> View this thread: http://www.excelforum.com/showthread.php?threadid=470857
>


 
 
MarianoB





PostPosted: Fri Oct 14 13:04:02 CDT 2005 Top

Excel Programming >> 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