Excel Event Problem

  • Thread starter Thread starter Bob J
  • Start date Start date
B

Bob J

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Workbook_Activate event 3
closing another file by code causes failure to run workbook activate event 2
Message for Bob Phillips 2
Private Sub Workbook_Open() 3
Problem with workbook on_open event 1
Save as crashes Excel - sometimes 7
Excel process still shows in TaskManager 7
Able to catch Application.Quit similar? 4

Back
Top