Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
freezing panes in group edit mode
Hi all
Quick and easy question - hopefully. In Excel, is it posisble to freeze panes whilst in group edit mode? The actual freee panes option isn't greyed out but it only seems to have been applied to Sheet1, although they were all grouped. Thank you. Louise |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
freezing panes in group edit mode
I don't think so.
You could record a macro that freezes panes and then cycle through the selected worksheets, though. Option Explicit Sub testme() Dim wks As Worksheet Dim myAddr As String myAddr = "C3" For Each wks In ActiveWindow.SelectedSheets wks.Activate ActiveWindow.FreezePanes = False wks.Range("a1").Select wks.Range(myAddr).Select ActiveWindow.FreezePanes = True Next wks End Sub The code removed any existing freeze panes, then selected A1 (so that it would be visible), then selected C3 and froze panes there. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Louise wrote: Hi all Quick and easy question - hopefully. In Excel, is it posisble to freeze panes whilst in group edit mode? The actual freee panes option isn't greyed out but it only seems to have been applied to Sheet1, although they were all grouped. Thank you. Louise -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
freezing panes in group edit mode
Worked perfectly, thank you. VBA isn't my strongest point but I thought
there would be a code I could use. Thanks again. Louise "Dave Peterson" wrote: I don't think so. You could record a macro that freezes panes and then cycle through the selected worksheets, though. Option Explicit Sub testme() Dim wks As Worksheet Dim myAddr As String myAddr = "C3" For Each wks In ActiveWindow.SelectedSheets wks.Activate ActiveWindow.FreezePanes = False wks.Range("a1").Select wks.Range(myAddr).Select ActiveWindow.FreezePanes = True Next wks End Sub The code removed any existing freeze panes, then selected A1 (so that it would be visible), then selected C3 and froze panes there. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Louise wrote: Hi all Quick and easy question - hopefully. In Excel, is it posisble to freeze panes whilst in group edit mode? The actual freee panes option isn't greyed out but it only seems to have been applied to Sheet1, although they were all grouped. Thank you. Louise -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate cell row and column | Excel Discussion (Misc queries) | |||
Need help w/ Weight Formula | Excel Discussion (Misc queries) | |||
Using Group Mode in Excel...Cursor behavior. | Excel Discussion (Misc queries) | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |