Problem inserting images in VBA forms in Excel on a Mac

[Guest]

Hi, and thanks in advance for any help or direction you can provide.

I'm trying to fix a problem with an Excel file that won't run properly on a
Mac. The file was created on a PC, and contains forms with an image that
seem to be "breaking" the macros. I'm new to Excel on the Mac, so please be
gentle.

Here's why I think it's the image and not some other ActiveX-related issue:

First, if I remove the image from the forms in the original (problematic) PC
file, the macros seem to work fine -- both on PC and Mac.

Second, I ran isolated tests of various form elements (e.g., buttons, radio
buttons) both on the Mac and on the PC. Those limited elements worked fine
on both files (Mac-created and PC-created) and on both OS's (Mac and Win),
*until* I inserted the image on the PC version. That PC version then
wouldn't run on the Mac. When I tried to insert an image on the Mac version,
it wouldn't even allow me to select a file to insert (all image file names
were greyed out) until I selected 'All Files' instead of just 'Picture
Files'... and even then, it didn't end up inserting *anything*.

So: Original PC file, no image = runs fine. New image, new PC file = won't
run on Mac. New image, new Mac file = won't allow me to insert image.

Has anyone encountered the same issue before, or have any idea what could be
causing this problem?

I'm using Mac OS X 10.4.6 and Excel 2004 for Mac 11.2.3 , plus Win XP 2002
w/ SP2 and Excel 2003 w/ SP2.

Many thanks again from a Mac n00b.

 

[Norman Jones]

Hi Bernadette,

See the following post in the mac.office.excel group:

http://tinyurl.com/q5v53

 

[Guest]

Hi, Norman.

Thanks so much for your reply, and for the helpful link.

Unfortunately, I had stumbled upon a similar suggestion in another forum
that mentioned the .bmp compatibility issue, and I've tried with no luck to
craft a workaround using that new knowledge. Again, what happens is: if I
insert a .bmp into a form on the PC file, then try to open it on the Mac, it
won't run. If I try to create a new form on the Mac using a .bmp file, it
spits out an error code -- something like 8800A...., which doesn't yield any
insight, even w/ a google search.

This is so frustrating! Yes, I know, I'm late to the compatibility pity
party... but I at least need to show up.

Thanks for your direction, though -- at least I'm trying the right things...
or at least some of them.

-- Bernadette

 

[Norman Jones]

Hi Bernadette,

Unfortunately my knowledge of Macs is severely limited.

I would suggest, however, that you additionally post your query in the
microsoft.public.mac.office.excel group.

 

[Guest]

Thanks again, Norman. Posted to microsoft-dot-etc-etc-etc earlier today
-- no takers so far . But at least there's hope (or the illusion of
such).

Greatly appreciate the pointers,
Bernadette