Problem inserting images in VBA forms in Excel on a Mac

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.

Hi Bernadette,

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

http://tinyurl.com/q5v53


---
Regards,
Norman



"Bernadette" <Bernadette@discussions.microsoft.com> wrote in message
news:F6FA3236-E245-4B73-AC0F-3BD4DA5208A1@microsoft.com...
> 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.

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" wrote:

> Hi Bernadette,
>
> See the following post in the mac.office.excel group:
>
> http://tinyurl.com/q5v53
>
>
> ---
> Regards,
> Norman
>
>
>
> "Bernadette" <Bernadette@discussions.microsoft.com> wrote in message
> news:F6FA3236-E245-4B73-AC0F-3BD4DA5208A1@microsoft.com...
> > 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.
>
>
>

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.


---
Regards,
Norman



"Bernadette" <Bernadette@discussions.microsoft.com> wrote in message
news:BA34388F-6D64-4260-B851-685B166E5BF8@microsoft.com...
> 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
>

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

"Norman Jones" wrote:

> 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.
>
>
> ---
> Regards,
> Norman
>
>
>
> "Bernadette" <Bernadette@discussions.microsoft.com> wrote in message
> news:BA34388F-6D64-4260-B851-685B166E5BF8@microsoft.com...
> > 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
> >
>
>
>