Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default Freeze Panes Question

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?

--
NealMed
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default Freeze Panes Question

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

"NealMed" wrote:

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?

--
NealMed

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 freeze panes won't freeze top row only macbone2002 Excel Discussion (Misc queries) 3 April 22nd 23 03:07 AM
freeze panes? gregp22 Excel Discussion (Misc queries) 1 April 2nd 06 06:15 AM
freeze panes? gregp22 New Users to Excel 3 April 2nd 06 03:37 AM
Freeze Panes rexmann Excel Discussion (Misc queries) 4 June 9th 05 04:00 PM
Not quite "Freeze Panes"..... chris Excel Discussion (Misc queries) 1 January 25th 05 07:09 PM


All times are GMT +1. The time now is 02:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"