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
--
Roger


"Billy Liddel" wrote:

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