Roger

In the workbook module (right-click the Excel Icon on the left of the Menu
Bar and selet View code) and use these events

Private Sub Workbook_Activate()
Your code here
End Sub

Private Sub Workbook_Deactivate()
Your code here
End Sub

Regards
Peter

"Roger" wrote:

is there an event that will run if a workbook is restored after it has been
minimised
--
Roger