Ronnie

You could put code in the Workbook_Open() event like so

Private Sub Workbook_Open()
MsgBox "You must enter data in Cell A1 first", vbOKOnly + vbQuestion
Worksheets("Sheet1").Activate
Range("A1").Select
End Sub

It fires when the workbook is open, displays a msgbox, activates sheet1 and
selects A1 on that sheet

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Ronnie Coleman" wrote in message
...
I need someone entering information to a worksheet to
enter into a specific cell first. It must be the first
thing they do so is there a way to code a message box
which would pop up to say "you must enter a value in A1
before anywhere else" if they try and enter anywhere else?

Thanks