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

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

Re: FreezePanes is a window property

Show all headers | View raw

In message <o2fn0h$vvl$1@dont-email.me> of Fri, 9 Dec 2016 20:51:31 in
microsoft.public.excel.programming, GS <gs@v.invalid> writes
>> In message <FcbTtsfeEoSYFwLj@freenetname.co.uk> of Fri, 9 Dec 2016
>> 10:02:06 in microsoft.public.excel.programming, Walter Briscoe
>> <wbriscoe@nospam.demon.co.uk> writes
>>> I run Excel 2003.
>>> I have a particular workbook, consisting of 3 sheets.
>>> Sometimes, I save it with one displayed sheet and sometimes with
>>>more than one.
>>> Each sheet had FreezePanes set.
>>> I sometimes lose FreezePanes, when I switch from sheet to sheet.
>>> After some considerable time being irritated with this, I now
>>>understand it.
>>> I wrote my first event procedure - I don't count auto_open.
>>
>> [snip]
>>
>>> Where are events enumerated?
>>
>> By googling excel event name descriptions, I found worksheet events
>> enumerated and described in
>> <https://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.w
>> orksheet_events.aspx>
>> I also found
>> <https://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.w
>> orkbook_events.aspx>
>> I can probably find others.
>
>Note that you can manage sheet events in ThisWorkbook as you've done
>here, but that it can also be done with an events handler class. This
>might be a better alternative since all code in ThisWorkbook is subject
>to not work correctly if the workbook becomes corrupted for any reason.
>

Where would I put an events handler class to escape corruption?
I find Microsoft's standard events are not raised as I expect.
e.g. <https://msdn.microsoft.com/en-us/library/microsoft.office.tools.ex
cel.workbook_events.aspx> says:
SheetActivate  Occurs when any sheet is activated.

When a workbook is opened, "Open  Occurs when the workbook is opened.",
but SheetActivate is not raised, even if a sheet is shown on screen.

My only experience of classes is copies I have made in the last couple
of weeks.
-- 
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