Workbook Open & Calendar Control
 

Hi,
I just tried using a userform with a calendar control that works with excel 2002 on a machine with excel 2003. It didn't work. Were you able to get yours to work?
Any help would be greatly appreciated.

peter

"LEB" wrote:

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.