Hi All
I am creating a macro to ensure that when the workbook opens it always opens on the first worksheet in the workbook. This worksheet will constantly have a different name so the line "Sheets("First Worksheet Name").Select" which I originally wrote will not work.
Can anyone advise the code so that the firstwork sheet is active on opening.
Tanks
DM
I am creating a macro to ensure that when the workbook opens it always opens on the first worksheet in the workbook. This worksheet will constantly have a different name so the line "Sheets("First Worksheet Name").Select" which I originally wrote will not work.
Can anyone advise the code so that the firstwork sheet is active on opening.
Tanks
DM