Running Macro/VBA in multiple worksheets.
I am trying to run a Macro (which works perfectly) in €śAll€ť Worksheets of a
particular Workbook. I currently have seven Worksheets in the Workbook and
have to select each Worksheet and manually run the Macro. I will eventually
have 50 (maybe more) Worksheets where the Macro will need to be run. I have
used the €śPrivate Sub€ť code in VBA but can only get it to execute the Macro
in the active Worksheet when the Workbook opens.
Is there code that could/would run the Macro in €śAll€ť the Sheets? Sheet1,
Sheet2, Sheet3, Sheet4€¦
Any help would be greatly appreciated.
--
SHD
|