View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How to set a specific column always visible in the excel sheet

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

"Ahmed Maaloul" wrote:

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