use macro to hide or show bitmap image
 

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.

use macro to hide or show bitmap image
 

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,

---
Regards,
Norman



"John Davies" wrote in message
...
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.