MS Excel Position cursor in Cell C2 in all sheets in a workbook
Posted on 2013-11-14
I am looking for a macro that would place the cursor in Cell C2 of all sheets of a workbook when the file is opened -- regardless of where the cursor was at the time of save. I also need the first sheet of the workbook to be in focus when the file is opened. I currently have the following code running for "all worksheets"; however, when the file is opened, the last sheet is in focus (instead of the first). Any help is greatly appreciated!
Private Sub Workbook_Open()
Dim WSheet As Worksheet
For Each WSheet In Worksheets