L
LEB
Several days ago, I asked for help on a Workbook Open
procedure that was not running, and the calendar control
in Office. I have resolved those issues, and wanted to
post the solution, in case it helps someone else.
WorkBook Open
My Workbook_Open procedure was running only when I opened
a new instance of Excel, and was it failing to run when I
closed and reopened the workbook, without closing Excel.
The problem (get out the dummy stick) was a procedure
that ran in the BeforeClose workbook event. It was
turning off event processing to prevent cascading event
triggers, but I had accidentally erased the code to turn
event processing back on when the procedure ended.
Calendar Control
I could not get the Office XP 2002 calendar control to
run in a friend's Office 2003 spreadsheet. The problem
wasn't the control, but was a reference set in the Visual
Basic Tools...References menu of the VB editor. For some
reason, Norton SystemWorks SpeedDisk had set a library
reference within the workbook I was programming, and that
reference was carried with my spreadsheet when I mailed
it to my friend. I have not yet determined how or why
SystemWorks set this reference, and I haven't found it in
any other workbooks on my PC.
procedure that was not running, and the calendar control
in Office. I have resolved those issues, and wanted to
post the solution, in case it helps someone else.
WorkBook Open
My Workbook_Open procedure was running only when I opened
a new instance of Excel, and was it failing to run when I
closed and reopened the workbook, without closing Excel.
The problem (get out the dummy stick) was a procedure
that ran in the BeforeClose workbook event. It was
turning off event processing to prevent cascading event
triggers, but I had accidentally erased the code to turn
event processing back on when the procedure ended.
Calendar Control
I could not get the Office XP 2002 calendar control to
run in a friend's Office 2003 spreadsheet. The problem
wasn't the control, but was a reference set in the Visual
Basic Tools...References menu of the VB editor. For some
reason, Norton SystemWorks SpeedDisk had set a library
reference within the workbook I was programming, and that
reference was carried with my spreadsheet when I mailed
it to my friend. I have not yet determined how or why
SystemWorks set this reference, and I haven't found it in
any other workbooks on my PC.