showing/hiding an image with a button

**redbullah** · 05-04-2010, 11:08 AM

hello, is it possible to assign a macro to a button that will hide a specified image on the worksheet/or show if it's hidden?

**Domski** · 05-04-2010, 11:20 AM

Something like this should do the trick:

Sub Test()

With Sheets("Sheet1").Shapes("Picture 1")

    If .Visible Then
    
        .Visible = False
        
    Else
    
        .Visible = True
        
    End If
    
End With

End Sub

Dom

**redbullah** · 05-04-2010, 11:51 AM

thanks but i don't know where picture1 is. i have multiple images on my worksheet, so how can i assign them names?

**Domski** · 05-04-2010, 12:04 PM

If you select a picture it's name will appear in the Name Box in the top left hand corner of the screen.

Dom

**redbullah** · 05-04-2010, 12:21 PM

thanks for your time Domski, it surely did the trick

i just wrote the name of my worksheet that includes the images that i want to hide instead of Sheet1, and the name of the picture instead of Picture 1 and it worked!