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 |
load event when specific workbook is opened
Not sure what you mean by "specific event to be active as that workbook is
the active one". An event cannot be active. It is something you respond to by putting code in its signature. If that WB is not active, its Workbook_SheetActivate will not fire. Unless you turn off events (Application.EnableEvents=False) all events are available in the active WB/WS depending where the code resides. If you use Application Level Events (http://www.cpearson.com/excel/AppEvent.htm) the whole of Excel is available to you. NickHK "itsthebike" wrote in message ... 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 |
load event when specific workbook is opened
Nick, Thanks for your reply. As a relative VB novice, please pardon my incorrect terminology. What I'm trying to accomplish is something similar to the following: Sub Workbook_Open() ''Call the 'sub' Workbook_Activate End Sub ------------------------------- Sub Workbook_Activate() Workbook_Activate End Sub ------------------------------- Sub Workbook_Deactivate() Workbook_Deactivate End Sub = = = = = = = = = = = = = = = = What I need to happen is: - target WB is opened - then, anytime any WS in the target workbook is the active WS, then have the code identified as "xWorkbook_Activate" (above) be activated once a certain action takes place (i.e. cursor moves based on an entry being made in a specific column). Hopefully this adds more understanding to the nature of the issue. Thanks. -- itsthebike ------------------------------------------------------------------------ itsthebike's Profile: http://www.excelforum.com/member.php...o&userid=27425 View this thread: http://www.excelforum.com/showthread...hreadid=559201 |
All times are GMT +1. The time now is 06:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com