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

--
Jim
"Roger" wrote in message
...
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