Hello Everyone ...I have prepared 18 pivots using VBA (recording) in 12 different sheets.
I want to prepare a command center in sheet1 from where i can assign macros to various buttons and run them from their.But the problem is when i am trying to do that its not working.If i run these macros where they originally recorded they work fine no problem at all. But i really require solution for this why they are not working when i run them from sheet1.
Many thanks in advance
I want to prepare a command center in sheet1 from where i can assign macros to various buttons and run them from their.But the problem is when i am trying to do that its not working.If i run these macros where they originally recorded they work fine no problem at all. But i really require solution for this why they are not working when i run them from sheet1.
Many thanks in advance