Hi,
is it possible to change the width of the dropdwon list box of a report filter in a pivot table? It is too short and the names are not displayed completely. I don't want the user to increase the width every time they need to select an item in the list.
I hope someone can help me.
Thank...
Hello,
I need to change the Report Filter of a chart made on a pivot table just like explained here
http://chandoo.org/wp/2011/04/27/update-report-filter-macro/
The only difference is that I need to allow multiple selection. Is it possible to do so?
Do you have any suggestion? I can't...
Hi all!
I have problems with reopening a workbook via vba.
I need to run several macros on the same excel workbook.
Each macro deletes cells in the original workbook. Just to clarify, the original workbook contains data of 8 different users and I use the macros to create 8 workbooks, one...
Hello,
I have a bar chart with 400 (and even more) categories. Is it possible to look for a specific category name? I'd like a sort of 'find' function that searches through the categories names of the vertical axis and finds the category name you have typed.
According to your knowledge, is...