freezing panes in group edit mode

[Guest]

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]

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

 

[Guest]

Worked perfectly, thank you. VBA isn't my strongest point but I thought
there would be a code I could use.

Thanks again.
Louise