Several users on a network Excel file freeze rows in the worksheet.
Do you mean they freeze panes...
the places it ends up
frozen is very haphazard
or just that the sheet opens to a different range than intended?
Can I lock the freeze that should be maintained?
Not that I'm aware of - but you can use VBA to ensure that the file
displays what you intend when it's selected.
And, can freeze be done any other way than the drop-down menu?
Yes, with programming like VB.
Regardless, you can control what’s displayed when the file is opened:
Private Sub Workbook_Open()
'Make this the sheet you want displayed
Sheet1.Activate
'This tests to see if panes are frozen
'and unfreezes if they are
If ActiveWindow.FreezePanes = True _
Then ActiveWindow.FreezePanes = False
'make this the most upper-left cell
'that you want to be unfrozen
Range("a2").Select
'freeze the panes at your selection
ActiveWindow.FreezePanes = True
End Sub
See this site if you’re not familiar with using VBA:
http://www.contextures.com/xlvba01.html
and go to the part titled: Copy Code to a Workbook Module (the example
above is workbook code)
You’ll have to adjust the ranges in the example to get the results
that you want – this site may help:
http://support.microsoft.com/kb/291304/en-us
Cliff Edwards
