I am trying to setup a worksheet for others to use. But I need to be able to
have the cursor automatically jump to the next available field for entry. Is
there a way to set this up?
I am trying to setup a worksheet for others to use. But I need to be able to
have the cursor automatically jump to the next available field for entry. Is
there a way to set this up?
Hi Kay
If you use 2002-2003 there is a option when you protect your sheet to only select unlocked cells
Maybe you like that
--
Regards Ron De Bruin
http://www.rondebruin.nl
"Kay" <[email protected]> wrote in message news:[email protected]...
>I am trying to setup a worksheet for others to use. But I need to be able to
> have the cursor automatically jump to the next available field for entry. Is
> there a way to set this up?
try this code
Private Sub Workbook_Open()
Worksheets("Sheet1").EnableSelection = xlUnlockedCells
End Sub
HTH
Regards from Brazil
Marcelo
"Kay" escreveu:
> I am trying to setup a worksheet for others to use. But I need to be able to
> have the cursor automatically jump to the next available field for entry. Is
> there a way to set this up?
If you're using Excel 2003 you can unprotect the cells where data needs to be
entered by selecting the cells, clicking on FORMAT in the menu and then
select CELLS. In the formatting dialog box, click the PROTECTION tab, turn
the PROTECTED check box off and click OK to exit.
From the menu select TOOLS, then select PROTECTION from the drop-down menu
and PROTECT WORKSHEET from the cascade menu. In the ALLOW ALL USER OF THE
WORKSHEET TO list, turn SELECT LOCKED CELLS off and then assign a password.
Now the only cells the user can access are the ones that you unprotected for
data entry.
--
Kevin Backmann
"Kay" wrote:
> I am trying to setup a worksheet for others to use. But I need to be able to
> have the cursor automatically jump to the next available field for entry. Is
> there a way to set this up?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks