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

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

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

Are you looking to ensure that the user can not hide the column or do you
wnat the column to remain visible while the user scrolls left to right.

To ensure that the user cna not hie dht column you need to protect the
worksheet. Tools - Protection - Protect Sheet

To ensure that a column always stays visible when the user scrolls left to
right you can use Freeze Panes. You can look that up in the help to see how
it works...
--
HTH...

Jim Thomlinson


"Ahmed Maaloul" wrote:

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

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