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

i wanna change or format a picture on a Excel Sheet.
How can i do it

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 :)