![]() |
Other users are freezing without knowing it??
Several users on a network Excel file freeze rows in the worksheet. They are
not savy enough to know how to do it intentionally and the places it ends up frozen is very haphazard. Can I lock the freeze that should be maintained? And, can freeze be done any other way than the drop-down menu? |
Other users are freezing without knowing it??
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 |
All times are GMT +1. The time now is 01:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com