<div>
That is perfect. &nbsp;Thank you very much.
</div>


<div>
<div class="content wysiwyg-content">
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 &quot;all worksheets&quot;; however, when the file is opened, the last sheet is in focus (instead of the first). Any help is greatly appreciated! <br />
<br />
Private Sub Workbook_Open()<br />
Dim WSheet As Worksheet<br />
<br />
For Each WSheet In Worksheets<br />
WSheet.Activate<br />
Range(&quot;C2&quot;).Select<br />
Next<br />
End Sub
</div>
</div>


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
WSheet.Activate
Range("C2").Select
Next
End Sub

MS Excel Position cursor in Cell C2 in all sheets in a workbook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.