BravesPiano5
02-23-2013, 07:09 PM
Hello forum! I'm a bit of a VBA newbie as most of what I've learned has come from Google. :whistle:
...that said, I have a macro that creates a pivot table on a new sheet; I've also coded in a couple of slicers at the top however the formatting on the pivot goes away once the user selects an item in the slicer. I want to use the worksheet change function on a range of cells to ensure once the user selects a separate item in the slicer that the formatting is consistent (behind the scenes).
Is there a way to do the worksheet change function on a newly created WS?
...that said, I have a macro that creates a pivot table on a new sheet; I've also coded in a couple of slicers at the top however the formatting on the pivot goes away once the user selects an item in the slicer. I want to use the worksheet change function on a range of cells to ensure once the user selects a separate item in the slicer that the formatting is consistent (behind the scenes).
Is there a way to do the worksheet change function on a newly created WS?