Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic: Setting up a button to switch on/off a picture
Please help me create an a control button that will allow me to turn on/ off
a picture that I have inserted into an excel document. I had added a signature that will serve as a digital signature but the document but I would like to be able to control turning the signature on and off. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic: Setting up a button to switch on/off a picture
Here is a little macro to do that
Sub myPic With ActiveSheet.Shapes("Picture 1") .Visible = Not .Visible End With End Sub Add a button from the forms toolbar to the worksheet, and assign that macro to it. -- HTH Bob Phillips "jeb" wrote in message ... Please help me create an a control button that will allow me to turn on/ off a picture that I have inserted into an excel document. I had added a signature that will serve as a digital signature but the document but I would like to be able to control turning the signature on and off. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Are there any NON-Visual Basic solutions for inserting a picture based a derived or called filename? | Excel Worksheet Functions | |||
Invoking a Visual Basic macro from a Custom Toolbar Button | Excel Worksheet Functions | |||
Create and Use Button Menu using visual Basic in Excel | Excel Discussion (Misc queries) | |||
how to access a value from excel option button using visual basic? | Excel Programming | |||
Picture scaling in Visual Basic | Excel Programming |