I entered in your macro as listed and ran it, and it indeed did work. I
saved the workbook and then opened it up again, however, the cursor was not
in the location that I specified in the macro.

Furthermore, when I went to edit the macro, it did not appear in the macro
window??? Not sure what's going on.

"Gary''s Student" wrote:

Yes:

The following macro will put the cursor in Z100 whenever the book is opened:

Private Sub Workbook_Open()
Sheets("Sheet1").Activate
Range("Z100").Select
End Sub


must be put in ThisWorkbook code.
--
Gary's Student
gsnu200704


"MarkT" wrote:

In Excel 2003, running XP Pro

Is there a way to have the cursor always be placed in a certain cell when a
workbook is opened up - regardless of where the user left it when they exited
out last?

Thanks for your help!

Mark