shawntanner
New Member
- Joined
- May 4, 2006
- Messages
- 23
I don't know what I did, but somehow my Workbook_BeforeClose event will not work. I can't even step into it (F8). And, with my cursor in the event, when I press F5 (Run Sub/Userform), the Macros dialog box shows up (as if I'm not within an event). It only occurs in the BeforeClose event.
I even tried making a Workbook_BeforeClose event in a new workbook and just put a MsgBox "Will this work?" in it to test. F8 (step into) will not work (I just get the ding sound), but when I close the new workbook with the X button, the debugger will go to the break point I set on Private Sub Workbook_BeforeClose(Cancel As Boolean).
Any advice is greatly appreciated. Please let me know if I need to clarify anything.
Thanks in advance!
I even tried making a Workbook_BeforeClose event in a new workbook and just put a MsgBox "Will this work?" in it to test. F8 (step into) will not work (I just get the ding sound), but when I close the new workbook with the X button, the debugger will go to the break point I set on Private Sub Workbook_BeforeClose(Cancel As Boolean).
Any advice is greatly appreciated. Please let me know if I need to clarify anything.
Thanks in advance!