Results 1 to 3 of 3

Thread: Excel 07 Image Display Issue

  1. #1

    Excel 07 Image Display Issue



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need help figuring out an issue with Excel 2007. An application I've built uses a macro to display an image based on a previous set of selections from drop down menus. For some reason the images are not being displayed on screen when the macro runs. I know the macro is functional as the visibility of the image changes to visible in the Selection Pane, but still no display. At this point, I save and close the application, with selections already made. When I reopen the saved application, the images appear just fine. I then change the selection of the 3rd Drop Down Menu and the image changes per the macro. If, however, I change the selection on either of the first two drop down menus, which subsequently hide all images and the third drop down menu and then modify the selections, I get the original problem. The images won't appear again.

    Code is spot on. Excel says the image is visible, it is just not displaying on the screen. It wouldn't be as big a deal if I didn't need to see the image in question, but that is what the entire application is based on.

    Is there a possibility that the number of images that are embedded into the sheet is causing the problem? This application is fairly image intensive and if so I'll need to find another way to display the required images instead of just a visible = true/false statement.

    Any help is much much appreciated. Thanks.

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Will be easiest to troubleshoot if you can upload a sample spreadsheet.

  3. #3
    Here is the file in question.Descent Game E-mail 2.zip

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •