make only a range selectable

You can protect (and unprotect) the sheet as needed with code...would that solve your problem? You could use any combination of criteria in an IF statement to decide when to protect/unprotect, with or without a password.

First run the following code. This will collor all your workbook grey except range("a2:b3"). You can do it manually too

After at worksheet event place code:

This is the code i'm currently using. but it does not work if the page is protected were you can select any cell

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Count > 1 Then Exit Sub
If Target.Row < 10 Then Exit Sub
If Target.Row > 28 Then Exit Sub
If Target.Row Mod 2 <> 0 Then Exit Sub
Application.ScreenUpdating = False
ActiveSheet.Unprotect
Cells(Target.Row, 4).Copy



Range("$D$4").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Application.ScreenUpdating = True

End Sub

How do i make it so this code works even when the whole page is protected and your not able to select any cells

Why don't you try the selectionchange instead of before double click:

To prevent selection of any cells(s) in A2:B3 :-


In addition, to prevent dragging data from any cells(s) in A2:B3 to cells outside of A2:A3 :-

How about this? Right click on the sheet tab and select View code. Once you are in VBA screen Press F4. In the Properties Window make a change next to Scroll Area. Change it to a2:b3. Save your workbook so that the change to that sheet will still be in effect the next time you open the workbook. Hey no code and you didn't protect the sheet either. Someone can select a range by putting something like A2:E14 in the address bar and pressing enter. This also effects a named range that can be selected from the address bar. If a range is selected in this manner then it is possible to edit the cells if you tab through the cells. However most people wouldn't think of this. You could actually use it to your advantage. You would know how to edit the named ranges, but others wouldn't know most likely. If you need to skip around the page then hold down the Ctrl key while selecting each cell in the order you would like to tab through them. Now with the cells still selected type a name for them in the address bar and press enter. You could create several named ranges for different sections of your sheet. When you want to edit that section just choose its name from the address bar pull down and tab through or press enter. Remember the cells can be noncontiguous and in any order imaginable.

babycody

And how would you prevent data from A2:B3 being dragged into other cells?

You can't drag data outside of that range. I forgot to mention you can tab in reverse by pressing Shift and tab at the same time, or Shift and Enter.

You can't drag data outside of that range.

Click to expand...

You can if the sheet's not protected.