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

  • Thread starter Thread starter Ahmed Maaloul
  • Start date Start date
A

Ahmed Maaloul

Hello,
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How pull ID#s that meet specific "yes" requirements 3
Keeping certain columns/rows visible 2
Pasting into a filtered sheet 3
"cannot shift objects off sheet" error 8
force first page view 8
Hiding columns in the mail 2
AutoFilter column w/merged cells 2
Start sheet in a workbook 2

Back
Top