I used the camera icon to make a preview window/picture of a range of cells.. In that range I am creating a label basically. I then use the camera icon to take a snapshot of that area and then paste in on the sheet 11 more times. This way I have a full sheet of 12 labels (labels for sticking on a chemical bottle, OSHA MSDS info).
The question I have is about the shape object or picture that is created. It does not look as clear as the original cells that it is taking a picture of. I select the "picture" and I get the Picture Tools - Format tab from pop up. From there I can go to the "Corrections" drop down and there is a sharpen option. I can also go to format the picture and I see "Sharpness" slider and text box. But when I go to make changes to any of these they just go back to 0%.
Is there something I am doing wrong or can this only be changed by code?
I have some code, see below, that will change the brightness and contrast but nothing that changes the Sharpness of the picture, that I can find.

Does anyone know how to increase the sharpness or resolution of the picture taken by the camera icon?

Thanks
Scott Riddle


Sub TestCode()
'
ActiveSheet.Shapes.Range(Array("Picture 65")).Select
ActiveSheet.Shapes.Range(Array("Picture 65")).PictureFormat.IncrementBrightness = 0.1
ActiveSheet.Shapes.Range(Array("Picture 65")).PictureFormat.Contrast = 0

End Sub