Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Busselton, Western Australia, Australia
    Posts
    59
    Thanks
    1
    Thanked 2 Times in 2 Posts

    Graphics on multiple sheets (Excel2k SR1a)

    Hi all, I am trying to work out how to insert a graphic onto many different sheets (ie a logo of some kind) by only inserting the graphic (logo) once ie into a setup sheet. On the target sheets I want to be able to set the size of the logo as required but I need to reference the graphic from the setup sheet.
    Any ideas on how I can do this would be greatly appreciated!
    Thanks
    Brian.

  2. #2
    Lounger
    Join Date
    Apr 2002
    Location
    Los Angeles, California, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graphics on multiple sheets (Excel2k SR1a)

    <img src=/S/lightbulb.gif border=0 alt=lightbulb width=15 height=15> This is an Excel97 code fragment that may give you some ideas.
    "Picture 1" is the Excel shape object. In my case there was only one shape object; a picture.

    Sub PictureResizeAndCopy()

    On Error GoTo NoPicture
    ActiveSheet.Shapes("Picture 1").Select
    Selection.ShapeRange.ScaleHeight 0.5, True <font color=blue>change picture size</font color=blue>
    Selection.ShapeRange.ScaleWidth 0.5, True
    Selection.Copy
    <font color=blue> ||||||<----------- Put the destination sheet code here </font color=blue>
    Application.Goto Reference:="R1C1" <font color=blue>This is destination position of logo</font color=blue>
    ActiveSheet.Paste

    NoPicture:

    End Sub


    HTH <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    Star Lounger
    Join Date
    Apr 2002
    Location
    Busselton, Western Australia, Australia
    Posts
    59
    Thanks
    1
    Thanked 2 Times in 2 Posts

    Re: Graphics on multiple sheets (Excel2k SR1a)

    Thanks!
    This looks like it will give me what I need as a starting point!
    Regards
    Brian.

Posting Permissions

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