Could you give an example of the XLM code you are using and the crash log
Here's a chunk of the macro:
=SELECT("startdate2")
=CLEAR()
=DIALOG.BOX(dateselectiondialog)
=RETURN()
I tried another worksheet that has a macro with a bunch of dialog boxes, and
the first 3 or 4 worked OK, but then it hits one that kills it, just as in
the case of the one above. In this second worksheet, the dialog boxes that
do work are all very simple: just text with an OK button, or a single list
of options in a list box, plus an OK button. The one that kills it, on the
other hand, has roughly 20 text labels and input fields. So that kind of
makes a little sense, but as you can see below, the dateselectiondailog is
also very simple, and that kills it, too, so....?
And here's the "dateselectiondialog" table
61 60 395 151
5 9 13 Enter the first date you want sheets printed for (m/d/yy):
8 41 45 171
1 145 96 64 OK
And from the log (I assume you didn't want the long list of loaded modules,
but I have it it you need it):
Error Signature:
Exception: EXC_BAD_ACCESS
Date/Time: 2008-06-19 15:09:58 -0500
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Version: 12.1.0.080409
Crashed Module Name: Microsoft Excel
Crashed Module Version: 12.1.0.080409
Crashed Module Offset: 0x00652aa1
Blame Module Name: Microsoft Excel
Blame Module Version: 12.1.0.080409
Blame Module Offset: 0x00652aa1
Application LCID: 1033
Extra app info: Reg=en Loc=0x0409
Thread 0 crashed:
# 1 0x00653aa1 in __mh_execute_header + 0x00652AA1 (Microsoft Excel +
0x00652aa1)
# 2 0x00508f81 in __mh_execute_header + 0x00507F81 (Microsoft Excel +
0x00507f81)
# 3 0x00603b44 in __mh_execute_header + 0x00602B44 (Microsoft Excel +
0x00602b44)
# 4 0x00604208 in __mh_execute_header + 0x00603208 (Microsoft Excel +
0x00603208)
# 5 0x0050c9f7 in __mh_execute_header + 0x0050B9F7 (Microsoft Excel +
0x0050b9f7)
# 6 0x0024d01d in __mh_execute_header + 0x0024C01D (Microsoft Excel +
0x0024c01d)
# 7 0x0024e542 in __mh_execute_header + 0x0024D542 (Microsoft Excel +
0x0024d542)
# 8 0x00118545 in __mh_execute_header + 0x00117545 (Microsoft Excel +
0x00117545)
# 9 0x0011132e in __mh_execute_header + 0x0011032E (Microsoft Excel +
0x0011032e)
# 10 0x0018b928 in __mh_execute_header + 0x0018A928 (Microsoft Excel +
0x0018a928)
# 11 0x0018025e in __mh_execute_header + 0x0017F25E (Microsoft Excel +
0x0017f25e)
# 12 0x0019e0a9 in __mh_execute_header + 0x0019D0A9 (Microsoft Excel +
0x0019d0a9)
# 13 0x0019e207 in __mh_execute_header + 0x0019D207 (Microsoft Excel +
0x0019d207)
# 14 0x001a43ec in __mh_execute_header + 0x001A33EC (Microsoft Excel +
0x001a33ec)
# 15 0x0018025e in __mh_execute_header + 0x0017F25E (Microsoft Excel +
0x0017f25e)
# 16 0x005aeb58 in __mh_execute_header + 0x005ADB58 (Microsoft Excel +
0x005adb58)
# 17 0x96c608e7 in _gHelpers + 0x96C2F507 (AE + 0x000108e7)
# 18 0x0149200a in _McpBrushApply + 0x000030B4 (MicrosoftComponentPlugin +
0x0003400a)
# 19 0x91166763 in .objc_class_name_IPMDFontRange + 0x90E3CB43 (HIToolbox +
0x00007763)
# 20 0x91165b9d in .objc_class_name_IPMDFontRange + 0x90E3BF7D (HIToolbox +
0x00006b9d)
# 21 0x911824ee in .objc_class_name_IPMDFontRange + 0x90E588CE (HIToolbox +
0x000234ee)
# 22 0x01491a8c in _McpBrushApply + 0x00002B36 (MicrosoftComponentPlugin +
0x00033a8c)
# 23 0x96c52648 in _gHelpers + 0x96C21268 (AE + 0x00002648)
# 24 0x96c5257e in _gHelpers + 0x96C2119E (AE + 0x0000257e)
# 25 0x96c52425 in _gHelpers + 0x96C21045 (AE + 0x00002425)
# 26 0x9119147d in .objc_class_name_IPMDFontRange + 0x90E6785D (HIToolbox +
0x0003247d)
# 27 0x005adcaf in __mh_execute_header + 0x005ACCAF (Microsoft Excel +
0x005accaf)
# 28 0x00858e5f in __mh_execute_header + 0x00857E5F (Microsoft Excel +
0x00857e5f)
# 29 0x0051dc59 in __mh_execute_header + 0x0051CC59 (Microsoft Excel +
0x0051cc59)
# 30 0x008913e6 in __mh_execute_header + 0x008903E6 (Microsoft Excel +
0x008903e6)
# 31 0x00891cfb in __mh_execute_header + 0x00890CFB (Microsoft Excel +
0x00890cfb)
# 32 0x008902c2 in __mh_execute_header + 0x0088F2C2 (Microsoft Excel +
0x0088f2c2)
# 33 0x000026ae in __mh_execute_header + 0x000016AE (Microsoft Excel +
0x000016ae)
# 34 0x000025d5 in __mh_execute_header + 0x000015D5 (Microsoft Excel +
0x000015d5)
X86 Thread State:
eax: 0x00000000 ebx: 0x00000040 ecx: 0x00000000 edx:0x00000001
edi: 0x00000003 esi: 0x00508f60 ebp: 0xbfff3608 esp:0xbfff35f0
ss: 0x0000001f eip: 0x00653aa1 cs: 0x00000017 ds:0x0000001f
es: 0x0000001f fs: 0x00000000 gs: 0x00000037 eflags:0x00010286
Thread 1:
# 1 0x94d435c6 in _signgam + 0x94BA3D86 (libSystem.B.dylib + 0x000015c6)
# 2 0x94dcc29b in _signgam + 0x94C2CA5B (libSystem.B.dylib + 0x0008a29b)
# 3 0x020efd7d in _MerpCreateSession + 0x00000B07 (merp + 0x00002d7d)
# 4 0x020ef3e5 in _MerpCreateSession + 0x0000016F (merp + 0x000023e5)
# 5 0x020ef46c in _MerpCreateSession + 0x000001F6 (merp + 0x0000246c)
# 6 0x020eff25 in _MerpCreateSession + 0x00000CAF (merp + 0x00002f25)
# 7 0x94d746f5 in _signgam + 0x94BD4EB5 (libSystem.B.dylib + 0x000326f5)
# 8 0x94d745b2 in _signgam + 0x94BD4D72 (libSystem.B.dylib + 0x000325b2)
X86 Thread State:
eax: 0xffffffa6 ebx: 0x94dbb0bf ecx: 0xb00a0a5c edx:0x94d435c6
edi: 0x0002cc2b esi: 0xed6ac8d0 ebp: 0xb00a0ac8 esp:0xb00a0a5c
ss: 0x0000001f eip: 0x94d435c6 cs: 0x00000007 ds:0x0000001f
es: 0x0000001f fs: 0x0000001f gs: 0x00000037 eflags:0x00000206
Thread 2:
# 1 0x94d4a68e in _signgam + 0x94BAAE4E (libSystem.B.dylib + 0x0000868e)
# 2 0x94d7536d in _signgam + 0x94BD5B2D (libSystem.B.dylib + 0x0003336d)
# 3 0x97151460 in __CMProfileID + 0x9707E33C (ColorSync + 0x00033460)
# 4 0x97163d92 in __CMProfileID + 0x97090C6E (ColorSync + 0x00045d92)
# 5 0x94d746f5 in _signgam + 0x94BD4EB5 (libSystem.B.dylib + 0x000326f5)
# 6 0x94d745b2 in _signgam + 0x94BD4D72 (libSystem.B.dylib + 0x000325b2)
X86 Thread State:
eax: 0x0000014e ebx: 0x94d7538d ecx: 0xb0122e7c edx:0x94d4a68e
edi: 0x0485b9a4 esi: 0xb0123000 ebp: 0xb0122ef8 esp:0xb0122e7c
ss: 0x0000001f eip: 0x94d4a68e cs: 0x00000007 ds:0x0000001f
es: 0x0000001f fs: 0x0000001f gs: 0x00000037 eflags:0x00000246
Thanks for your help!
kevin
