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 Pane Multiple Worksheets 1

Status
Not open for further replies.
Randy11

Randy11

Technical User
Oct 4, 2002
175
CA
Would like to Freeze Panes multiple worksheets with freeze point as B5.
Would like to do this for the 1st 20 sheets in the workbook.
Have been unable to select multiple wortksheets & apply Freeze panes. Your ideas appreciated....
 
Sort by date Sort by votes
Each one must be ACTIVE when the FREEZE is executed. Loop thru each one.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
328
combo
combo
remeng
  • Locked
  • Question
multiple err handling
Replies
6
Views
311
remeng
remeng
arvarr
  • Locked
  • Question
Excel Help - Worksheets by UserID 3
2
Replies
39
Views
489
arvarr
arvarr
remeng
  • Locked
  • Question
Multiple Users in a Macro enabled Excel Doc
Replies
0
Views
151
remeng
remeng
feipezi
  • Locked
  • Question
How to find a string from multiple Word files, which are listed on an Excel spreadsheet? 3
Replies
17
Views
387
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top