Moving from unlocked cells to unlocked cells in an excel form

[Stacey Lee]

I am trying to create a form in excel and I want staff to be able to move
from one unlocked cell to the next after it has been password protected. I
have tried the help menu, but it would be easier if there were a function
that simply allowed you to move from one unlocked cell to the next. My first
locked cell is moving to one that is four lines below it.

Any help is appreciated.

Stacey Lee

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[Gord Dibben]

Stacey

If you have unlocked just the cells you want your users to access, the Tab key
will move you from one to the next in a left to right, top to bottom manner.

See Bob Phillips' site for this and more methods.

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

There is another method using VBA with worksheet event code.

Post back if you want to try that.


Gord Dibben Excel MVP

On Mon, 24 Apr 2006 11:51:01 -0700, Stacey Lee <Stacey

I am trying to create a form in excel and I want staff to be able to move
from one unlocked cell to the next after it has been password protected. I
have tried the help menu, but it would be easier if there were a function
that simply allowed you to move from one unlocked cell to the next. My first
locked cell is moving to one that is four lines below it.

Any help is appreciated.

Stacey Lee

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

Gord Dibben MS Excel MVP