Trouble with images in VBA forms

A

aplia.jobs

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

I've had trouble running macros that were created on a PC, on a new
Mac. First I thought it had to do with various code-related issues, or
ActiveX controls, but after running isolated tests of different
elements, it seems that the bottleneck may in fact be an image that was
embedded in all of the forms.

If I remove the image from the forms in the file on the PC, the macros
seem to work fine -- both on PC and Mac.

If I insert a new image in a new form in a new file created on the PC,
the form won't function on the Mac.

If I try to do the same thing on the Mac (create a new form in a new
file and insert an image), it won't allow me to select any images. The
image filenames are greyed out by default in the selection box, until I
change the File Type box to "All Files" instead of "Picture Files",
even though they are standard .jpg and .bmp files. Even then, when I
select a picture file and click the button to insert it, it doesn't
show up on the form.

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.
 
M

Mark Perka-MS

Not all image files are created equal :) -- sorry -- couldnt resist saying
that. :) What I would suggest for your image files
is to ensure that you can view the images in both mac and pc excel in just a
regular ol' worksheet before you try putting them in vb forms. This
would be the best technique I could offer to assist you with your problem.

Hope this helps.

note: This posting implies no warranties or guarantees.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top