Tab/Enter from cell to cell

rac2664

New Member
Joined
Aug 5, 2007
Messages
1
Is there a way to tab or enter from cell to cell if I have set up my worksheet with protection for different individuals to enter information only in certain cells? I would like for the individuals to be able to start at the first cell (that they can enter information) and then tab or enter to get to the next cell that they can enter information. Looking for an order to the tabbing or entering. . .
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
1. Press Alt-F11 to get to the code window
2. Click on the sheet name on the left under microsoft excel objects
3. If you can't already see the properties window press F4
4. Change EnableSelection to 1- XlUnlockedCells

I couldnt work out how to do it without goiing through the code window, so hopefully that helps!
 
Upvote 0

Forum statistics

Threads
1,214,804
Messages
6,121,652
Members
449,045
Latest member
Marcus05

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top