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.