Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Freeze Panes

Status
Not open for further replies.
rss01

rss01

Technical User
Oct 10, 2001
125
US
I have code that sends a query from Access to Excel formated. I want to freeze the top row of the worksheet. Any ideas??? Everything I've tried doest work
 
Sort by date Sort by votes
The following freezes the top row of a worksheet (sheet2)

Sub freeze()
Worksheets("sheet2").Activate
Range("A2").Select
ActiveWindow.FreezePanes = True
End Sub
 
Upvote 0 Downvote
This is what I ended up using.

xlsWorksheet.Rows(2).Select
xlaApplication.ActiveWindow.FreezePanes = True
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PeDa
  • Locked
  • Question
Excel VBA split panes not working consistently 1
Replies
5
Views
87
Andrzejek
Andrzejek
Jonnylaw91
  • Locked
  • Question
VB Macros freezes/Times out 2
Replies
11
Views
89
Jonnylaw91
Jonnylaw91
UnsolvedCoding
  • Locked
  • Question
Freeze panes and subtotals 1
Replies
6
Views
45
UnsolvedCoding
UnsolvedCoding
Randy11
  • Locked
  • Question
Freeze Pane Multiple Worksheets 1
Replies
1
Views
28
SkipVought
S
Malc8179
  • Locked
  • Question
Screen freeze when running code
Replies
3
Views
43
fumei
fumei

Part and Inventory Search

Sponsor

Back
Top