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

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

Re: FreezePanes is a window property

From Walter Briscoe <wbriscoe@nospam.demon.co.uk>
Newsgroups microsoft.public.excel.programming
Subject Re: FreezePanes is a window property
Date 2016-12-09 13:43 +0000
Organization A noiseless patient Spider
Message-ID <y4ie0uB4TrSYFweC@freenetname.co.uk> (permalink)
References <FcbTtsfeEoSYFwLj@freenetname.co.uk> <o2e0lq$luq$1@dont-email.me>

Show all headers | View raw

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. ;)
-- 
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