Defining tabs

timkunde

New Member
Joined
Jul 29, 2002
Messages
12
And another one:

I'd like to define a certain kind of format for my sheet. When it's protected, users should only be able to enter data into two columns, say B and D.
So, clearly, I have to protect the other cells.
What is more, I'd like other users to be able to 'jump' from one data cell to the next using "tab". So, after they enter a value in cell B2, they press tab and they automatically get to cell D2. Next tab is B3, then D3...

It'd be also lovely if the cursor is always in Cell B2, when opening the file.

Cheers

Tim
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Sir Vili

Board Regular
Joined
Jul 11, 2002
Messages
148
Hello timkunde.

Do this way:

1. Select first B2. Take Format Cells. Select Protection Sheet on Dialog. Remove v from Locked. Continue same way with all cells You want to be accessed by Tab.

2. Then once finished, then take from Menu [TOOLS][PROTECTION][PROTECT SHEET]. Remove v from Select Locked Cells. Be sure that You have v on Select Unlocked Cells. OK.

Cursor always in Cell B2, when opening the file, for that You need VBA code.

BRGDS Sir Vili.
 

timkunde

New Member
Joined
Jul 29, 2002
Messages
12
Works fine.

Here's the challenge:
I need the protection (with the tabs) and an automatic filter to work at the same time. Without macro, I can only activate EITHER the filter OR the protection.

Possible?

Thanks

Tim
 

timkunde

New Member
Joined
Jul 29, 2002
Messages
12
Works fine.

Here's the challenge:
I need the protection (with the tabs) and an automatic filter to work at the same time. Without macro, I can only activate EITHER the filter OR the protection.

Possible?

Thanks

Tim
 

Sir Vili

Board Regular
Joined
Jul 11, 2002
Messages
148
Code on module:

Sub Filter_Open()
Sheets("Sheet1").Select
ActiveSheet.Protect UserInterfaceOnly:=True
ActiveSheet.EnableAutoFilter = True
End Sub

Note:
When You are setting protection on, please checkmark also Use Autofilter. Note this is valid for XP.

BRGDS Sir Vili
 

Forum statistics

Threads
1,148,051
Messages
5,744,520
Members
423,881
Latest member
Nguyen Vu

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
Top