Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert an excel sheet to txt with specific column size Marco Excel Discussion (Misc queries) 1 October 31st 07 12:46 PM
Finding Number of cells in a column of other sheet having a specific word in them [email protected] New Users to Excel 5 February 21st 07 01:51 PM
Copy a whole Word doc into Excel sheet & keep it all visible? Jackstri Excel Discussion (Misc queries) 1 February 16th 06 01:56 PM
Excel sheet not visible New group user 944 Excel Discussion (Misc queries) 4 June 16th 05 11:11 PM


All times are GMT +1. The time now is 10:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"