Hi!
I have pivot table that consists of 3 elements
Left Column is a store name
Next Colum of Table is a Grand total field of Sold Quantity and Unsold Quantity of items.
I created 4 macros and assigned them to 4 different buttons :
1. Show Salesperson Name
2. Hide Salesperson Name
3. Show Manager's Name
4. Hide Manager's Name
I recorded these macros in the order shown above.
The problem comes in when I try to click only on Macro 3 because when the macro was written the Salesperson's name was already there.
In order to have an error-free experience and see the Manager's name you need to click on both in that order.
Is there a statement that can be added to the vba code to circumvent this issue?
Thanks in advance!!!
I have pivot table that consists of 3 elements
Left Column is a store name
Next Colum of Table is a Grand total field of Sold Quantity and Unsold Quantity of items.
I created 4 macros and assigned them to 4 different buttons :
1. Show Salesperson Name
2. Hide Salesperson Name
3. Show Manager's Name
4. Hide Manager's Name
I recorded these macros in the order shown above.
The problem comes in when I try to click only on Macro 3 because when the macro was written the Salesperson's name was already there.
In order to have an error-free experience and see the Manager's name you need to click on both in that order.
Is there a statement that can be added to the vba code to circumvent this issue?
Thanks in advance!!!