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
ActiveSheet.Shapes("your picture").Select With Selection.ShapeRange.PictureFormat .Brightness = 0.6 ' % 0 - 1 .Contrast = 0.6 ' ' % 0 - 1 .ColorType = msoPictureGrayScale End With
ActiveSheet.Pictures.Insert("c:\YourFolder\YourPicture.jpg").Select
Forum Rules