ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Event Problem (https://www.excelbanter.com/excel-programming/284882-excel-event-problem.html)

Bob J[_2_]

Excel Event Problem
 
I can trap the opening and closing of a workbook when it
is first opened or closed at the event and Thisworkbook
level. However, if Thisworkbook is closed and then
reopened immediately an open event is not triggered or
trapped. Can anyone help me with this?

Thanks for your assistance...

Bob J.

Colo

Excel Event Problem
 
Bob

Please let us have your code.

--
Kind Regards
Colo
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo of 'The Road of The Cell Masters' :)

URL:http://www.interq.or.jp/sun/puremis/...astersLink.htm


/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/


"Bob J" wrote in message
...
I can trap the opening and closing of a workbook when it
is first opened or closed at the event and Thisworkbook
level. However, if Thisworkbook is closed and then
reopened immediately an open event is not triggered or
trapped. Can anyone help me with this?

Thanks for your assistance...

Bob J.




All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com