Prevent a sheet from scrolling but keeps the hyperlink clickable? 1

[tbtcust]

Hello All,

I have a worksheet that has hyperlinks in some of the cells. I am using a macro to prevent scrolling on this worksheet. When I prevent the scrolling, via Developer tab ===> Properties ===> ScrollArea A1:Y1 the hyperlink are not clickable.

Is there a way to prevent a sheet from scrolling but keeps the hyperlink clickable?

Thanks in advance for any help.

 

[combo]

If you need a part of the sheet non-scrollable, freeze panes (above and to the left of selected cell).

combo

 

[tbtcust]

Hello combo,

Thank you for the post. This only gets me part way there. The user can still scroll right.

Any other suggestions would be greatly appreciated.

 

[combo]

As one can freeze only relatively to selected cell that has to be visible while freezing, set window's zoom to 10%, select bottom-right cell, freeze panes and reset zoom to previous value. You should have all window locked.

combo

 

[tbtcust]

Hello combo. This does work. I see what I was doing wrong. This is resolved. Thank you.