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.
Excel VBA Training and Certification (Lesson 1 is free)
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.