use macro to hide or show bitmap image

[John Davies]

I have scanned my signature and saved it as a bitmap image that I would like
to use in an Excel spreadsheet. However I do not want the signature to be
visible all the time. Is it possible to assign the bitmap to a macro button
that will change the colour of the bitmap to the background colour of the
sheet to make it invisible and vice versa.

 

[Norman Jones]

Hi John,

Try something like:


Private Sub CommandButton1_Click()
With ActiveSheet.Shapes("Picture 1") '<<===== CHANGE
.Visible = Not .Visible
End With
End Sub

The button will toggle the display of the bitmap,