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?

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?

Could you explain a little bit further, maybe with an example.

Thanks.

"Bob Phillips" wrote:

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?

Try this code



Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
MsgBox "Previous sheet was" & Sh.Name
MsgBox "Active sheet is " & ActiveSheet.Name
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cordobes" wrote in message
...
Could you explain a little bit further, maybe with an example.

Thanks.

"Bob Phillips" wrote:

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?