Results 1 to 4 of 4

Hiding / unhiding pictures based on cell value

Threaded View

  1. #3
    Registered User
    Join Date
    02-05-2011
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    56

    Re: Hiding / unhiding pictures based on cell value

    Hi Patel,

    Thanks. Yes, .Left instead of .Right solved part of the problem.

    I also tracked down the second part of the problem. There's a type mismatch because not only the jpegs are detected as pictures, but also the start and reset button
    See for yourself.
     Sub Countpics()
    MsgBox Worksheets("Quiz").Pictures.Count
    End Sub
    gives 26 hits: 2 buttons and 24 pictures.

    when I remove those buttons, the code above works fine but the sheet itself is useless. :s

    The reason you didn't see pictures is probably because they were hidden by
     Me.Pictures.Visible = False
    I'm adding an updated version. Care to take another shot?

    Thanks a bunch!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1