Freeze column AG
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.
--
Regards
Roger Govier
wrote in message
oups.com...
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).
|