View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
itsthebike[_4_] itsthebike[_4_] is offline
external usenet poster
 
Posts: 1
Default load event when specific workbook is opened


After reading many threads on this topic, I still can't come up with the
proper coding to do what I want to do. When I open a specific workbook,
I'd like for a specific event to be active as long as that workbook is
the active one, and I'd like that specific event to activate for any
worksheet within the workbook.

I have used the Auto_Open event, and I thought I should call the
Workbook_Activate event from the Auto_Open. This doesn't seem to be
working. Suggestions for a workable solution??


--
itsthebike
------------------------------------------------------------------------
itsthebike's Profile: http://www.excelforum.com/member.php...o&userid=27425
View this thread: http://www.excelforum.com/showthread...hreadid=559201