Deactivate worksheet
If you use the Workbook_SheetDeactivate event, there is sheet argument which
refers tro the sheet exited from.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Cordobes" wrote in message
...
I want to reorganize and sort a good amount of information on a worksheet,
right before it is deactivate it.
The problem is that when the event deactivate is running, the active sheet
is no longer the one being deactivated, so I have to select it back again,
making it the active sheet, and put in place a set of boolean variables,
to
know if this action is taking place before deactivating the sheet, or
under a
regular activation.
Any suggestions?
|