Thanks Gord, I will look at the link you provided, this helps a great deal.
I've not done much in excel, infact if any program this one may be my weakest
in knowledge base. I would like to get a good direction on an Excel book,
one that gives you the more unknown goodies and programming. I know VB a
bit, used to know it like the back of my hand, but not using it for 14 months
it is just starting to come back.

Thank you again.
--
Continuously think of new ideas and do what it takes to create it.
"Gord Dibben" wrote:

Ken

First..if using Excel 2002 or 2003 version you can set option to not select
locked cells when setting up your ToolsProtectionProtect Sheet.

There are several ways to set the TAB order on worksheet cells.

See Bob Phillips' site for methods.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is another method using VBA event code.

If interested, post back for more detail and some sample code.


Gord Dibben Excel MVP

On Tue, 6 Dec 2005 16:38:02 -0800, Ken wrote:

I understand how to protect the whole sheet and allow certain cells to be
populated. two part question.

1) is there a way to allow the cursor to only spot or start with the
unlocked cells? Almost like a fillable PDF? I had an excel sheet where it
ignored the protected areas and only went to the unprotected user cells.

2) If the above cannot be done, how do you turn off that "this sheet is
protected" popup? My users will find out they can't change the sheet, but
don't want them to get as annoyed as I do when I accidently click the wrong
cell.

Thanks.