Events

[Guest]

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

 

[Guest]

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

 

[Guest]

thanks Billy but i have already tried these - they work when switching from 1
workbook to another but dont work if you minimise then restore - rog

 

[Jim Rech]

The Workbook_WindowResize event (in ThisWorkbook) may be what you want.