Locking Columns/Rows Together?

[Dishboy09]

I am attempting to find a way to lock my top row, AND 8 columns on the right side of my page so that they stay locked with the top row.

Any ideas on how/if this could be attained?

 

[Yongle]

Try this

Select cell I2
Click View tab \ FreezePanes\Freeze Panes

 

[Dishboy09]

Try this

Select cell I2
Click View tab \ FreezePanes\Freeze Panes

That locks all of the columns up to that point though. Im needing the first 20 columns free scrolling and the last 8 to be locked.

 

[Yongle]

How about selecting U2 and ViewTab\ SplitScreen
Hop into bottom left quadrant
If that won't do, then VBA is the answer

 

[Yongle]

Without VBA

Lock top row using Freeze Frame
Select columns A to T
Right click \ Format Cell\ Protection tab \ uncheck "Locked"
Protect the worksheet - do not allow user to select unlocked cells

Prevents straying outside your limits

 

[Yongle]

With VBA

Lock the Top Row with Freeze Frames

Place in sheet module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  If Target.Column > 20 Then Cells(Target.Row, 20).Activate
End Sub

 

[Dishboy09]

With VBA

Lock the Top Row with Freeze Frames

Place in sheet module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  If Target.Column > 20 Then Cells(Target.Row, 20).Activate
End Sub

Placed code into view code tab, and still only the top row is locked. Am i doing something wrong?

 

[Yongle]

Sounds like you have done everything correctly
Events trigger may be disabled

Save, Close and Re-Open the workbook - should then be ok