set focus

[RickK]

When opening any sheet in a workbook, I'd like to have a
the focus on a specific cell (say C,4). Any suggestions on
what to use in the Sheet_Activate function?

 

[pfsardella]

Private Sub Worksheet_Activate()
Cells(4, 3).Select
End Sub

HTH
Paul