Worksheet_Activate Not Called When Opening Workbook
Bob,
Thanks for shedding some light on this.
Doug
"Bob Phillips" wrote in message
...
That should read coalshed's, spellchecker got it!
Bob
"Bob Phillips" wrote in message
news:...
Hi Doug,
With the weather that we are having at the moment, I can hardly the
harbour,
never mind across it. From work, high on the 5th floor I can usually
glimpse
them at the moment.
That signature was inspired by a guy in the travel groups who signed
himself
as looking out across one of the lakes in the lake district (Windermere
IIRC), and I thought, this is a lovely place as well, a bit more
built-up
perhaps, but really nice, so I penned mine. I also recall many other
humorous ripostes to that one, such as 'looking down my garden to the
British Rail woolshed's, et al.
A change from the Zen mantras I fell<vbg.
Bob
"Doug Glancy" wrote in message
...
Bob,
I was wondering, are you no longer "looking out across Poole Harbour
to
the
Purbecks?" At one point I Googled it and it looks like a beautiful
part
of
the planet. I had also thought of signing myself as "looking across
my
stomach tomy toes" - my relaxed laptop position - but wasn't sure if
you
would appreciate the attempt at humor.
Doug Glancy
"Bob Phillips" wrote in message
...
You could either add it to the workbook_open event (but what happens
if
the
activesheet is some other?), or maybe check in workbook_open if that
sheet
is active and then load it.
--
HTH
RP
"Gaston" wrote in message
...
I'm using code in the Worksheet_Activate event to load a Menu.
This
works
fine when manually switching from one worksheet to another.
However,
when
the workbook is first opened, this event is not issued for the
active
sheet.
How can I get this event to run when the workbook is first opened.
The
active sheet can be any sheet that the user had activated prior to
the
last
worbook close.
|