Freeze Panes Question

N

NealMed

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?
 
F

FSt1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top