I am trying to apply to formats to a picture using VBA in Excel 2007. Unfortuneatly the macro recorder doesn't capture picture formatting, and I am having a difficult time locating any decent resources on the topic.
I am trying to do 2 things to the picture.
1. Add a solid line border with a 6.0 PT weight with the "Bevel" type corners.
2. Add the "Inside Center" preset shadow type and adjust the "Blur" amount to 33 PTS.
If anyone knows the correct expression to set these two properties, or knows of any decent resources on this topic, please reply!
)
Thanks!
I am trying to do 2 things to the picture.
1. Add a solid line border with a 6.0 PT weight with the "Bevel" type corners.
2. Add the "Inside Center" preset shadow type and adjust the "Blur" amount to 33 PTS.
If anyone knows the correct expression to set these two properties, or knows of any decent resources on this topic, please reply!
)Thanks!
