calling a worksheet function from another worksheet in same workbo
Sheet1.Worksheet_Deactivate
worked for me.
You'll have to make it Public though (or expose it through another Public
procedure).
Tim
"Liz" wrote in message
...
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!
|