Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Pivot table toolbar
Hello excellites,
I am building an excel app using an excel table and a pivot table. The table can grow by adding additional rows. There is a named range, "WORK_DETAILS", that includes the excel table that is dynamically set to the current region. I am trying to use a userform to control the pivot table (pvtSummary). To do this I am resetting the sourcedata property to the current value of the named range using the statement: pvtSummary.SourceData = BuildR1C1Range(Range("WORK_DETAILS")) where the function BuildR1C1Range converts the a1 address format of the named range into the R1C1 format. The assignment works fine. But when I execute this statement the pivot table toolbar is 'popping up'. How do I prevent the toolbar from appearing? I can probably hide it after the fact but I really would like to stop it from appearing in the first place. Thanks, Lee. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Toolbar | Excel Discussion (Misc queries) | |||
pivot table toolbar | Excel Discussion (Misc queries) | |||
Pivot Table Toolbar | Excel Discussion (Misc queries) | |||
How to you keep the Pivot Table Toolbar from unlocking? | Setting up and Configuration of Excel | |||
Pivot table toolbar | Excel Discussion (Misc queries) |