If you're using xl2002 and above, you can protect the worksheet and not allow
the users to select any locked cells. It's one of those options in the
protection dialog.

You could also turn off the ability to edit directly in the cell.
In xl2003 menus:
Tools|Options|edit tab|uncheck "Edit directly in cell"

But this is a user by user setting.

gab1972 wrote:

I have a sheet where all of the cells are locked. The cells are
populated from a separate sheet. I'm beta testing my workbook and
when I *double-click* a locked cell, I get a message box that says the
cell is locked and that you must remove the password
(...blah...blah..blah...) and then it takes me to the sheet that
populates the cell. I don't want this to happen. Do I need some sort
of Worksheet Change coding that keeps the user on that sheet??

Thanks in advance!

--

Dave Peterson