Right now I have a macro that clears certain cells on a sheet. I have 4 sheets, 4 macros and a button on each sheet to run each macro. I would like to create a macro that will run all 4 macros for their respective sheet and assign it to a button on my main sheet.
Sheet # Sheet Name Name of macro
Sheet1 HPSM Clear_Cells
Sheet7 EVIP-VIP Clear_Cells_EVIP
Sheet8 PCA Clear_Cells_PCA
Sheet9 PCR Clear_Cells_PAR