LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Workbook.Open Event Procedure not firing

Can anyone shed light why one of event procedures is not running.

I have a couple of workbooks whose formulae can link in either direction
depending on a control value held in a third "control" file. In order that
the status of that third file is always recognised I created a Workbook.Open
Event Procedure that Opens the control file if it is not already open. That
runs fine.(The procedure is held in Thisworkbook)

Recently I was fed up with getting too many divide by zero errors so I
included a small user-defined function in a code module to handle this. Now
my Workbook.Open Event procedure won't fire. If I remove the user-defined
function it fires. Confused? I was!

Anyone any ideas as to what is happening?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Workbook open event Pawan Excel Worksheet Functions 7 August 26th 08 07:32 AM
Event: open workbook Jeff Excel Discussion (Misc queries) 1 September 28th 06 02:58 PM
Workbook Open Event Paul D[_2_] Excel Programming 0 October 17th 03 02:39 AM
Workbook Open Event Dave Peterson[_3_] Excel Programming 0 October 17th 03 02:38 AM
OnTime event not firing in Workbook_Open event procedure GingerTommy Excel Programming 0 September 24th 03 03:18 PM


All times are GMT +1. The time now is 08:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"