Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109750

Re: FreezePanes is a window property

Show all headers | View raw

In message <y4ie0uB4TrSYFweC@freenetname.co.uk> of Fri, 9 Dec 2016
13:43:20 in microsoft.public.excel.programming, Walter Briscoe
<wbriscoe@nospam.demon.co.uk> writes
>In message <o2e0lq$luq$1@dont-email.me> of Fri, 9 Dec 2016 11:24:09 in
>microsoft.public.excel.programming, Claus Busch <claus_busch@t-
>online.de> writes
>>Hi Walter,
>>
>>Am Fri, 9 Dec 2016 10:02:06 +0000 schrieb Walter Briscoe:
>>
>>>     With ActiveWindow
>>>         .SplitColumn = 1
>>>         .SplitRow = 1
>>>         .FreezePanes = True
>>>     End With
>>
>>> Can I simplify?
>>
>>with SplitColumn =1 you freeze column A (1) and with
>>SplitRow=1 you freeze row 1. There is no need to select a cell.
>>Try for all sheets:
>>
>>Private Sub Workbook_SheetActivate(ByVal Sh As Object)
>>With ActiveWindow
>>    .SplitColumn = 1
>>    .SplitRow = 1
>>    .FreezePanes = True
>>End With
>>End Sub
>Thanks, Claus. I agree.
>I don't know how I got it wrong. ;)

I now think I was right.
Set the window so the top left hand cell shows [8,1}
Transfer focus to a second sheet
Return to first sheet and Run
        With ActiveWindow
            .SplitColumn = 1
            .SplitRow = 1
            .FreezePanes = True
        End With

SplitColumn and SplitRow are relative to what the window shows.
We want data relative to the Worksheet displayed in the Window.
-- 
Walter Briscoe

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

FreezePanes is a window property Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-12-09 10:02 +0000
  Re: FreezePanes is a window property Claus Busch <claus_busch@t-online.de> - 2016-12-09 11:24 +0100
    Re: FreezePanes is a window property Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-12-09 13:43 +0000
      Re: FreezePanes is a window property Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-12-10 11:26 +0000
  Re: FreezePanes is a window property Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-12-09 13:37 +0000
    Re: FreezePanes is a window property GS <gs@v.invalid> - 2016-12-09 20:51 -0500
      Re: FreezePanes is a window property Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-12-10 11:58 +0000
        Re: FreezePanes is a window property GS <gs@v.invalid> - 2016-12-10 19:07 -0500
          Re: FreezePanes is a window property GS <gs@v.invalid> - 2016-12-10 19:42 -0500
  Re: FreezePanes is a window property DungSports <DungSports@gmail.com> - 2016-12-09 14:49 +0000

csiph-web