Results 1 to 2 of 2

Thread: how can i change or format a picture on a Excel Sheet.

  1. #1

    Thread Starter
    New Member
    Join Date
    Mar 2001
    Location
    Istanbul - Turkey
    Posts
    1
    i wanna change or format a picture on a Excel Sheet.
    How can i do it

  2. #2
    Junior Member RichG-W's Avatar
    Join Date
    Mar 2001
    Location
    Bradford(the curry capital of the UK), West Yorkshire, England
    Posts
    22
    To reformat a picture using VBA

    Code:
    ActiveSheet.Shapes("your picture").Select
    With Selection.ShapeRange.PictureFormat
            .Brightness = 0.6 ' % 0 - 1
            .Contrast = 0.6 '  ' % 0 - 1
            .ColorType = msoPictureGrayScale
     End With
    to add a picture using VBA

    Code:
    ActiveSheet.Pictures.Insert("c:\YourFolder\YourPicture.jpg").Select
    I hope this was the sort of thing you were after

Posting Permissions

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



Click Here to Expand Forum to Full Width