Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Events
is there an event that will run if a workbook is restored after it has been
minimised -- Roger |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Events
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Events
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Events
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
do events? background events | Excel Programming | |||
events? | Excel Discussion (Misc queries) | |||
add-ins & events | Excel Programming | |||
On Events | Excel Programming | |||
how do I log events | Excel Programming |