How to set a specific column always visible in the excel sheet

M

Mike H

Ahmed,

I'm not sure precisely whay you mean but this

Private Sub Worksheet_Activate()
Application.GoTo Cells(1, 10), True
End Sub

would ensure column 10 (J) would be the leftmost column every time the sheet
is selected.

Right click the sheet, view code and paste it in

Mike
 
Top