Freeze column AG

  • Thread starter Thread starter fornewsgroups
  • Start date Start date
F

fornewsgroups

x-no-archive:
Hi all,
I want to freeze column AG but be able to scroll between columns A to
AF.
So far I can only do the opposite (ie. scroll AFTER column AG onwards).
 
Hi

Right click on the Sheet tab and choose View Code, and this will invoke
the Visual Basic Editor.
If the Properties Window is not visible, press F4.
In the Properties, scroll down to Scroll Area and set this to A1:AF1000
(or whatever row number you wish to lock to)
You will now be confined to scrolling within that area.

This setting only persists whilst the workbook is open and will be lost
upon closing (even if you save).

If you wish it to persist, you will need to set some code in the
Workbook Open event as follows

Private Sub Workbook_Open()
ThisWorkbook.Sheets("Sheet1").ScrollArea = "A1:AF1000"
End Sub

Copy the code above and paste it into the ThisWorkbook module of the
Visual Basic Editor.
If the Project Explorer is not visible and you can't see ThisWorkbook,
press Ctrl + R to bring up the explorer.
 
x-no-archive:
Hi all,
I want to freeze column AG but be able to scroll between columns A to
AF.
So far I can only do the opposite (ie. scroll AFTER column AG onwards).

If you want AG to stay in position while you scroll the columns to the
left of AG then you can split the screen.
Move the cursor down to the bottom right corner where you see a little
square at the bottom of the vertical scroll bar and to the right of the
horizontal scroll bar. Move the cursor to the left until it turns into
a double horizontal arrow, then click and drag the screen splitter to
the left until there is just enough room to view a column the width of
column AG. Use the right scroll bar to get AG into view on the right of
the screen. Scroll with the left scroll bar to position the columns to
the left of AG.

To remove the split either drag it back to the right or go
Window|Remove split

Ken Johnson
 
You could also create a New Window (Menu Window New) - Shape the new
window (which should bear the :2 designation versus your original window
:1) to show starting with AG..? (also make size smaller )- Just a
thought...
Jim
 
x-no-archive:

Hi all. MUCH thanks for your input.
The split screen occurred to me but I was hoping for a simpler answer.
The visual basic stuff is VERY good to know for future reference.
Again many thanks and HAPPY NEW YEAR!!
 

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


Back
Top