Freeze Panes Question

[Guest]

I have built and excel worksheet that has now become a Shared Workbook in my
office. The trouble I am having is that, I have the dates at the top and have
freeze paned to keep them there. When i share the workbook, it stays set for
me, but others using it have to freeze panes themselves, is there a way to
freeze them while unshared and then share it keeping that setting for
everyone?

 

[Guest]

hi,
try an auto run macro like this...

Private Sub Workbook_Open()
Range("A2").Select 'change to your setting
ActiveWindow.FreezePanes = True
End Sub

Paste it in a thisworkbook module.

Regards
FSt1