Finding an event

  • Thread starter Thread starter Peter Ostermann
  • Start date Start date
P

Peter Ostermann

Hello,
I am developing an app that uses a single worksheet to enter data. When user double clicks a button, a new window (in same workbook)
opens with a new sheet. My problem is that excel does not seem to have any events for close of window if there are multiple windows
in a workbook.
Can someone help

Peter
 
Peter,

That triggers the Workbook_WindowActivate event, you can use that.


HTH

Bob

"Peter Ostermann" wrote in message

Hello,
I am developing an app that uses a single worksheet to enter data. When user
double clicks a button, a new window (in same workbook)
opens with a new sheet. My problem is that excel does not seem to have any
events for close of window if there are multiple windows
in a workbook.
Can someone help

Peter
 
Back
Top