Killing off the rest of the sheet

[Manhar]

If the data on a sheet is confined to range, say A1 to
M60, how does one render the rest of the sheet
ineffective so that cell selection is confined to the
above range? Thanks!

 

[kkknie]

You could hide the extra rows and columns (or set their widths/height
to 0). Or you could do it in a worksheet_selectionchange event. Thi
would keep them from moving out of the range on that worksheet. If yo
want that solution, let me know and I'll post it.

 

[Gord Dibben]

Manhar

You can hide the rows and columns you don't want used and protect the sheet
after un-locking A1:M60.

If using Excel 2002 or 2003 you have many options for selecting on a protected
sheet.

See options under Tools>Protection>Protect Sheet.

You may want to try setting the Scroll Area.

This setting will not remain after closing the file.
Place a code line in the Workbook open event to set it
each time when you open the workbook

Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "A1:M60"
End Sub

Adjust to your sheetname and range.

Gord Dibben Excel MVP