Selectiong MULTIPLE Sheets in 'ThisWorkbook' using "With Sheets" Command

Hi!

I have a workbook that has 50 sheets within it.

They are called (from left to right);

Bet Angel / Bet Angel (2) / Bet Angel (3)... etc

I have the following VBA code which Runs a Macro after 5 seconds have passed when the WorkBook is opened;

Please Login or Register  to view this content.

Obviously this only Runs the Macro for the sheet "Bet Angel".


How to i add the rest and get it to run the Macro for all the sheets after 5 seconds of the WorkBook been opened?

I have tried using an & sign and also comas and a few other attemps. Whats the correct way to add tyhe other sheets to this code?


Any help greatly appreciated!


Andy

Hi!

So sorry for the late reply guys!

Yes those both work perfectly, thank you for taking your time. Rep left


Im learning everyday but sometimes get stuck on the simpler tasks.