Thread: set focus
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pfsardella@yahoo.com is offline
external usenet poster
 
Posts: 96
Default set focus

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

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
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?