How to freeze panes using VBA
Requirement:
Is it is possible, in VBA, to freeze the panes of a worksheet at a specific cell?
Solution:
Code:
Private Sub Worksheet_Activate()
Application.Goto Range("A2"), True
ActiveWindow.FreezePanes = True
End Sub
Obtained from the OzGrid Help Forum.
Solution provided by Dave Hawley.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to data trim and clean cell values with VBA code |
| How to use Excel VBA userform list box |
| How to maximise IE window in VBA |
| How to generate multiple line charts VBA |
| How to create VBA to copy specific column from one sheet to another |
| How to use VBA to returning 5 left digits and pasting to bottom of existing data set |
| How to download a file using VBA |
| How to use VBA script to count files/subfolders using a range from WB for the root folder |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
