set focus

RickK · Oct 10, 2003

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 · Oct 10, 2003

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

HTH
Paul

set focus

RickK

pfsardella