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: 2
Default Workbook_Open does not run for Addin

I have an addin which handles events for certain workbooks. It makes
itself available through a menu bar. During the process of opening a
new workbook, it is supposed to catch the Workbook_open event and
check if the workbook being opened is something it should handle, if
it is, the menu is shown, if not, it does nothing. The addin also
handles other events such as double clicking on cells .

After some period of using the workbook with the addin enabled, it
seems to just stop handling events. I am checking that
Application.EnableEvents is still true and it is. But all events are
unhandled, including(it seems) workbook_open. Now, the workbook_open
event that is defined is in the addin's workbook... but it seems to
handle everything most of the time.

If anyone can give me a hint at what to look for I would appreciate
it. Sorry, I can't really post the code due to length and corporate
restriction. I'm just trying to figure out if there's a VBA guru out
there that has seen this sort of behavior before.

Thanks

 
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
setup project for Excel addin, won't register addin Gerry Excel Programming 0 October 31st 07 12:01 AM
Call an addin Macro from Workbook_Open event [email protected] Excel Programming 2 August 29th 07 07:19 PM
Removing an Addin from the Tools Addin list. Trefor Excel Programming 2 August 25th 06 04:45 PM
Unshimmed Automation Addin and Shimmed COM Addin in same App Domai Brandon Excel Programming 0 June 27th 06 11:18 PM
Remove Excel AddIn from AddIn List !! Help carl Excel Programming 2 December 8th 03 03:36 PM


All times are GMT +1. The time now is 03:00 PM.

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

About Us

"It's about Microsoft Excel"