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.
|