On Jan 26, 1:26*pm, Dave Peterson wrote:
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

I actually have that feature (unable to select locked cells) enabled.
If I click on the cell, it doesn't highlight...but if I double-click
it, then I get that message box and it goes to the sheet and cell that
populated that locked cell.

Also, following your advice about turning that feature off (Edit
directly in cell), is this possible to disable this function with some
Workbook Open coding? I have some coding that turns off sheet tabs,
column and row headings, and all the menu bar items except for File
and Help...can I add some coding in here to do what you suggested?

Thanks.