Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Freezing Panes in Excel from Access

Freezing Panes in Excel from Access

Freezing Panes in Excel from Access

I have an Access database that contains code to generate Excel Workbooks/Sheets using information contained in the database.  The generated spreadsheets have various formatting and protection features enabled.  But what I can't figure out is how to freeze the panes in Excel from within the Access code while the workbook is being generated.  The users of the spreadsheet would like to be able to scroll through the page while the row & column headers remain visible.

The only property that seems to be even remotely close to what I'm trying to do is the Worksheet.ScrollArea property, but that doens't seem to do what I want.

Any help would be greatly appreciated.


RE: Freezing Panes in Excel from Access

Hi, this is an example of how to freeze the panes...

Dim appExcel As New Excel.Application
Dim strPath As String

'set workbook path

strPath = "C:\Test\Test.xls"

With appExcel
  'open excel and make application visible
  .Visible = True
  'Open workbook "C:\Test\Test.xls"
  .Workbooks.Open strPath

  'move to cell where you wish to freeze the panes

  'freeze panes
  .ActiveWindow.FreezePanes = True

  'Save workbook

  'Quit excel

End With

Set appExcel = Nothing

Hope this helps.

There are two ways to write error-free programs; only the third one works.

RE: Freezing Panes in Excel from Access

Thanks!  One purple star for you!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close