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. |
All times are GMT +1. The time now is 02:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com