Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Pivot Tables
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
vba courses london - Pivot Tables
Resolved · Low Priority · Version Standard
Reply Tue 27 Mar 2007, 16:42Delegate Christopher said...
Christopher has attended:
Excel VBA Intro Intermediate course
Pivot Tables
Is there a way to disable access to raw data on pivot tables?
For upcoming training course dates see: Pricing & availability
RE: Pivot Tables
Hi Christopher,
Yes, as I suggested, it turns out to be a settable property of a PivotTable object:
PivotTable.EnableDrilldown
e.g.
Sub ToggleDrilldown()
Dim pt As PivotTable
Dim status As Boolean
Set pt = Worksheets("PT Orders").PivotTables("PT_Orders")
status = pt.EnableDrilldown
pt.EnableDrilldown = Not (status)
End Sub
PivotTable has lots of properties! Might be worth a browse through the others.
/Roy
Reply Wed 28 Mar 2007, 12:27Delegate Christopher said...
RE: Pivot Tables
That's fantastic - thanks Roy.
Chris
Reply Wed 28 Mar 2007, 12:37Delegate Christopher said...
RE: Pivot Tables
I've found an easier way to do this. In the Table Options, you can uncheck the Enable Drill to Details box, protect the sheet and allow users to Use PivotTable reports.
|