Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have for a long time been making good use of a utility file based on Chip P's example of an Excel workbook that tracks Excel files being opened and then undertakes certain activities for specific files. After what I thought was just another routine editing session, I found an error when starting the Excel session the following day. The VBE was opened in step mode in the utility file at this point: Private Sub App_WorkbookOpen(ByVal Wb As Excel.Workbook) The utility is opened automatically by Excel from an alternate xlstart directory The file opens fine when taken out of the alternate xlstart directory and opened manually. Has anyone else had this or a similar problem? Up to now I have rectified it by going back to an earlier copy and trying to re-input the edits Thanks Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Launch Click Event Using Application.Run | Excel Discussion (Misc queries) | |||
captcure close application event | Excel Worksheet Functions | |||
Application level event help | Excel Discussion (Misc queries) | |||
Application.EnableEvents = true, but no event fires | Excel Programming | |||
Monitoring application-level event problem | Excel Programming |