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.

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.