I know that I should know how to do this, but I am obviously having a "blank"
moment. Can anyone help?

I want to call some code in the "Deactivate" event of one worksheet from
another worksheet.


--
It it''s meant to be, it won''t pass you by!

Sheet1.Worksheet_Deactivate

worked for me.

You'll have to make it Public though (or expose it through another Public
procedure).

Tim

"Liz" <(E-Mail Removed)> wrote in message
news:A67D107E-C50C-4E93-A38E-(E-Mail Removed)...
>I know that I should know how to do this, but I am obviously having a
>"blank"
> moment. Can anyone help?
>
> I want to call some code in the "Deactivate" event of one worksheet from
> another worksheet.
>
>
> --
> It it''s meant to be, it won''t pass you by!

Tim, thanks for the reply. I did not put down my question correctly. What I
want to do is on the Deactivate event of one worksheet, call a Function
("UpdChartMonth") that is a public function on another worksheet. The purpose
of UpdChartMonth is to update a chart on this "other" worksheet as a result
of changes being made on the first worksheet. Tks!
--
It it''s meant to be, it won''t pass you by!


"Tim Williams" wrote:

> Sheet1.Worksheet_Deactivate
>
> worked for me.
>
> You'll have to make it Public though (or expose it through another Public
> procedure).
>
> Tim
>
> "Liz" <(E-Mail Removed)> wrote in message
> news:A67D107E-C50C-4E93-A38E-(E-Mail Removed)...
> >I know that I should know how to do this, but I am obviously having a
> >"blank"
> > moment. Can anyone help?
> >
> > I want to call some code in the "Deactivate" event of one worksheet from
> > another worksheet.
> >
> >
> > --
> > It it''s meant to be, it won''t pass you by!
>
>
>

Assuming that you have a function called UpdChartMonth,

In your Deactivate procedure have you tried entering the line:

UpdChartMonth()



"Liz" wrote:

> Tim, thanks for the reply. I did not put down my question correctly. What I
> want to do is on the Deactivate event of one worksheet, call a Function
> ("UpdChartMonth") that is a public function on another worksheet. The purpose
> of UpdChartMonth is to update a chart on this "other" worksheet as a result
> of changes being made on the first worksheet. Tks!
> --
> It it''s meant to be, it won''t pass you by!
>
>
> "Tim Williams" wrote:
>
> > Sheet1.Worksheet_Deactivate
> >
> > worked for me.
> >
> > You'll have to make it Public though (or expose it through another Public
> > procedure).
> >
> > Tim
> >
> > "Liz" <(E-Mail Removed)> wrote in message
> > news:A67D107E-C50C-4E93-A38E-(E-Mail Removed)...
> > >I know that I should know how to do this, but I am obviously having a
> > >"blank"
> > > moment. Can anyone help?
> > >
> > > I want to call some code in the "Deactivate" event of one worksheet from
> > > another worksheet.
> > >
> > >
> > > --
> > > It it''s meant to be, it won''t pass you by!
> >
> >
> >

Similar to before:

Sheet1.UpdChartMonth

(adjusted based on the codename of the sheet containing UpdChartMonth)

Tim

"Liz" <(E-Mail Removed)> wrote in message
news:FC41B57F-08D8-48BF-AAA4-(E-Mail Removed)...
> Tim, thanks for the reply. I did not put down my question correctly. What
> I
> want to do is on the Deactivate event of one worksheet, call a Function
> ("UpdChartMonth") that is a public function on another worksheet. The
> purpose
> of UpdChartMonth is to update a chart on this "other" worksheet as a
> result
> of changes being made on the first worksheet. Tks!
> --
> It it''s meant to be, it won''t pass you by!
>
>
> "Tim Williams" wrote:
>
>> Sheet1.Worksheet_Deactivate
>>
>> worked for me.
>>
>> You'll have to make it Public though (or expose it through another Public
>> procedure).
>>
>> Tim
>>
>> "Liz" <(E-Mail Removed)> wrote in message
>> news:A67D107E-C50C-4E93-A38E-(E-Mail Removed)...
>> >I know that I should know how to do this, but I am obviously having a
>> >"blank"
>> > moment. Can anyone help?
>> >
>> > I want to call some code in the "Deactivate" event of one worksheet
>> > from
>> > another worksheet.
>> >
>> >
>> > --
>> > It it''s meant to be, it won''t pass you by!
>>
>>
>>

Tim, thanks for the quick response and, of course, you are correct!

Major Duh! moment!

Tks muchly
--
It it''s meant to be, it won''t pass you by!


"Tim Williams" wrote:

> Similar to before:
>
> Sheet1.UpdChartMonth
>
> (adjusted based on the codename of the sheet containing UpdChartMonth)
>
> Tim
>
> "Liz" <(E-Mail Removed)> wrote in message
> news:FC41B57F-08D8-48BF-AAA4-(E-Mail Removed)...
> > Tim, thanks for the reply. I did not put down my question correctly. What
> > I
> > want to do is on the Deactivate event of one worksheet, call a Function
> > ("UpdChartMonth") that is a public function on another worksheet. The
> > purpose
> > of UpdChartMonth is to update a chart on this "other" worksheet as a
> > result
> > of changes being made on the first worksheet. Tks!
> > --
> > It it''s meant to be, it won''t pass you by!
> >
> >
> > "Tim Williams" wrote:
> >
> >> Sheet1.Worksheet_Deactivate
> >>
> >> worked for me.
> >>
> >> You'll have to make it Public though (or expose it through another Public
> >> procedure).
> >>
> >> Tim
> >>
> >> "Liz" <(E-Mail Removed)> wrote in message
> >> news:A67D107E-C50C-4E93-A38E-(E-Mail Removed)...
> >> >I know that I should know how to do this, but I am obviously having a
> >> >"blank"
> >> > moment. Can anyone help?
> >> >
> >> > I want to call some code in the "Deactivate" event of one worksheet
> >> > from
> >> > another worksheet.
> >> >
> >> >
> >> > --
> >> > It it''s meant to be, it won''t pass you by!
> >>
> >>
> >>
>
>
>