Freeze Panes in Excel (via code)
Using VBA in Access 2003 I want to freeze the first two rows of the Excel spreadsheet within code. Manually from within Excel this would be Alt, Window, Freeze Pane
Thanks
Tony
Software/Hardware used:
Software/Hardware used:
ASKED:
April 20, 2005 10:18 AM
UPDATED:
May 19, 2005 1:31 PM
Answer Wiki:
Next examples works with excel 2002 and should work with 2003
Sub FreezeHorizontally()
Rows("2:2").Select //
ActiveWindow.FreezePanes = True
End Sub
Sub FreezeVertically()
Columns("B:B").Select
ActiveWindow.FreezePanes = True
End Sub
I hope this will help you.
To see all answers submitted to the Answer Wiki: View Answer History.
Thanks for the feedback, I’ll give this a try ASAP. It looks like it will do the trick.
Tony