+ Reply to Thread
Results 1 to 2 of 2

ClipArt to macro

  1. #1
    Glenn
    Guest

    ClipArt to macro

    First let me say I appreciate everyone's help. Me being a novice, you guys
    are a real help.
    I would like to make a macro that would let me insert a pic (clipart) onto a
    worksheet. This clipart would insert on a worksheet if certain values are
    true.
    THANKS
    Glenn

  2. #2
    Tom Ogilvy
    Guest

    Re: ClipArt to macro

    turn on the macro recorder and do

    Insert=>Picture, then from file etc.

    Position it where you want.

    Turn off the macro recorder. Modify the code to do what you want.

    To tie it to some condition, what generates the condition - someone editing
    a cell, a calculation?

    in any event:
    See Chip Pearson's page on Events
    http://www.cpearson.com/excel/events.htm

    --
    Regards,
    Tom Ogilvy


    "Glenn" <Glenn@discussions.microsoft.com> wrote in message
    news:E740ABB5-B751-403F-8E9B-9DDAAB000980@microsoft.com...
    > First let me say I appreciate everyone's help. Me being a novice, you

    guys
    > are a real help.
    > I would like to make a macro that would let me insert a pic (clipart) onto

    a
    > worksheet. This clipart would insert on a worksheet if certain values are
    > true.
    > THANKS
    > Glenn




+ 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