You need a VBA procedure to do this. In the ThisWorkbook code
module, enter

Private Sub Workbook_Open()
' change the sheet and cell reference as desired
Application.Goto Worksheets("Sheet2").Range("B2"), True
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Ron M." wrote in message
oups.com...
I want a specific cell to be selected when a worksheet is
opened, so
the user can go right to work without having to find that cell,
select
it, etc. I searched the newsgroup but can't find any articles
on how
to do this. Can somebody help?

Thanks,
Ron M.