Thread
:
Moving from unlocked cells to unlocked cells in an excel form
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
Posts: n/a
Moving from unlocked cells to unlocked cells in an excel form
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
wrote:
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/comm...et.f unctions
Gord Dibben MS Excel MVP
Reply With Quote