Mac version crashing

[MrT]

Hi there,

Just a few crashes I noticed with the Mac version (I'm mainly a PC user).

- Clicking on a hep button in a userform can make Excel crash
- Focus changes are not well managed causing Excel to crash. You need two
clicks sometimes to set the focus on a combobox.
- If a frame goes out of the displayed userform dimensions, the userform
might show the frame on the top left corner of the userform
- Having one userfrom hidden and another one displayed causes crashes
- ...

Of course for all these crashing situations, the problem does not occur on
the Windows Excel version.

I hope a service pack will be there before the next Mac Version.

Mr. T

 

[Bob Greenblatt]

Hi there,

Just a few crashes I noticed with the Mac version (I'm mainly a PC user).

- Clicking on a hep button in a userform can make Excel crash
- Focus changes are not well managed causing Excel to crash. You need two
clicks sometimes to set the focus on a combobox.
- If a frame goes out of the displayed userform dimensions, the userform
might show the frame on the top left corner of the userform
- Having one userfrom hidden and another one displayed causes crashes
- ...

Of course for all these crashing situations, the problem does not occur on
the Windows Excel version.

I hope a service pack will be there before the next Mac Version.

Mr. T

I'm not sure that these events are what is causing the crashes. Many of us
here use user forms extensively (one recent poster had 900 controls on a
user form) and have not seen crashes like this. I think you need to narrow
down the situation a bit more. The problem is probably somewhere in your
code. If the workbook is not proprietary you can email it to me and I will
take a look.

 

[jb]

My experience is that the Mac version is far, far more likely to crash
than the PC version. Most recently I've noticed this with drawing and
forms objects placed on a worksheet. I've got one sheet in which
something got messed up. Now the sheet instantly crashes Excel 2004
(Mac) and Excel 97 (PC) upon rendering. My wild guess in this case is
that there's an endianness bug in the code related to moving these
objects around that leads to objects getting unaligned or pointers to
them corrupted. To test this hypothesis I'll have to wait to see if
there's a native x86-OSX version of Excel to see if these problems go
away.

The bottom line is that Excel for Mac is a deprecated version of the
real thing. If running Excel in all of its glory is your first
priority, then you shouldn't be on Mac. If being on a Mac is your
first priority, you probably shouldn't depend on Excel.