Freeze Panes in Excel (via code)

pts.
Tags:
Development
Visual Basic
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TonyTempio
    Thanks for the feedback, I'll give this a try ASAP. It looks like it will do the trick. Tony
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following