MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

EnableItemSelection = False in Excel2000 ?

  Asked By: Jodon    Date: Nov 13    Category: MS Office    Views: 844

I am working on a VBA function that pulls in a query from an
Access2000 db, and builds some pivottables based on that data.

From what I can gather, there is in Excel2002 (and later versions...)
a way to "lock down" a pivot table using for example:

PT.EnableItemSelection = False

Is there a way to do this in Excel2000 with VBA?

Any other suggestions on how to "lock" a pivottable in 2000? All I
want the user to be able to do is to choose among the pagefields and
also refresh.