This is a discussion on Activate First Worksheet within the Excel Questions forums, part of the Question Forums category; Hi All I am creating a macro to ensure that when the workbook opens it always opens on the first ...
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.
worksheets(1).select will work.
You can relace the "1" with the number of the sheet you want (counting left to right)
There are three kinds of people - those that can count and those that can't.
Easy for the gurus.