Is that Rick?
ActiveSheet.Name returns the name of the worksheet whose tab was
clicked, deactivating the Sheet with the Worksheet_deactivate code.
Ken Johnson