+ Reply to Thread
Results 1 to 2 of 2

Visual Basic: Setting up a button to switch on/off a picture

  1. #1
    jeb
    Guest

    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. #2
    Bob Phillips
    Guest

    Re: 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" <jeb@discussions.microsoft.com> wrote in message
    news:B90A74C7-A5DE-4AA4-93CC-53E75B7E2F41@microsoft.com...
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1