ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   disable mulitple select on pivot page field (https://www.excelbanter.com/excel-programming/303825-disable-mulitple-select-pivot-page-field.html)

belinda

disable mulitple select on pivot page field
 
I have two olap pivot tables, set up so that if one page
field is changed, the same page field on the second pivot
table is changed to match.

However, if the user chooses to enable the "select
multiple items" on the page field, and then makes a
multiple selection from the page field, then the code
collapses.

Is there anyway that I can disable the "select multiple
items" box?

Alternatively, is there any way I can capture which items
have been selected when a user does a multiple selection?

Thanks

Belinda


All times are GMT +1. The time now is 07:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com