View Single Post
 
Old 11-17-2016, 10:20 AM
philosmarkxyz philosmarkxyz is offline Windows 7 32bit Office 2013
Novice
 
Join Date: Nov 2016
Location: DC
Posts: 1
philosmarkxyz is on a distinguished road
Default Manipulating shapes that already exist with VBA code

At my job, I'm constantly creating visual aids. I have to create red rounded rectangles, no fill, 2-point line. It would be great if I could write code to modify the rectangles after I've splatted them on my image. I do this several times, and it would be a great convenience to get it down to a keystroke.

I've read around on coding, and I'm having trouble getting my head around selecting shapes that already exist in the document vs. drawing them new in the code. I'm not sure how to code for an empty fill and I haven't seen code for the outline function in the ribbon.
Reply With Quote