Deactivate worksheet

[Guest]

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?

 

[Bob Phillips]

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)

 

[Guest]

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

Thanks.

 

[Bob Phillips]

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)