Display and edit a selected range range only?

[Johnnygripfast]

Hi all. I need to display only a selected range of cells in a Worksheet, for example, from A1:I55 for users to see and use?

[#2]

@Johnnygripfast 

Hi, 

you can use the following macro from my vba-Tanker. See attached file.

Sub Hide()

With ActiveSheet
.Range(.Columns(9), .Columns(16384)).Hidden = True
.Range(.Rows(56), .Rows(1048576)).Hidden = True
End With

End Sub

Sub show()

With ActiveSheet
.Columns.Hidden = False
.Rows.Hidden = False
End With

End Sub

Best regards from germany

Bernd