Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hlookup problem in knowing what range to use | Excel Worksheet Functions | |||
Share Workbook - Knowing who is in it. | Excel Discussion (Misc queries) | |||
Hyperlink to a file without knowing its extension | Excel Discussion (Misc queries) | |||
getting a y-value from a graph knowing the corresponding x-value | Excel Discussion (Misc queries) | |||
I need to remove a password on our timesheet without knowing the p | Excel Discussion (Misc queries) |