How to inactivate cells?

[prshnthvn]

Hello All,

I would like to know how to inactivate all cells except for the selected range of cells? Not just protecting the cells, i want them to be inactive.

Thanks in advance,
Regards,
Prashanth

 

[Jon von der Heyden]

Hi

What do you mean by 'inactive'? When you protect your sheet you have the option of not allowing users to even select locked cells in the list of options. I think that feature has been present since XL2000...

 

[VoG]

Is this what you mean?

Sub test()
With ActiveSheet
    .ScrollArea = Selection.Address
End With
End Sub

 

[prshnthvn]

Sorry, I was not clear before. I want only a range of cells to be visible in the sheet. I don't want other cell to be visible.

Thanks & Regards,
Prashanth

 

[Jon von der Heyden]

Ah ok, that would probably be best done by hiding columns and rows. Lets say al you want to see if A1:Z100
Highlight all rows from row 101, right-click > hide.
Highlight all columns from column AA, right-click > hide.

 

[VoG]

Try

Sub test()
With ActiveSheet
    .Columns("F:IV").Hidden = True
    .Rows("10:65536").Hidden = True
End With
End Sub