Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-17-2016, 10:20 AM
philosmarkxyz philosmarkxyz is offline Manipulating shapes that already exist with VBA code Windows 7 32bit Manipulating shapes that already exist with VBA code Office 2013
Novice
Manipulating shapes that already exist with VBA code
 
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
  #2  
Old 11-17-2016, 04:22 PM
macropod's Avatar
macropod macropod is offline Manipulating shapes that already exist with VBA code Windows 7 64bit Manipulating shapes that already exist with VBA code Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,342
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

So why not create a suitablly formatted autoshape and save it as a custom Quick Part? No code required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
fill, outline, shapes

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Manipulating 3D objects in Powerpoint 2013 MScrazy PowerPoint 0 05-27-2014 02:29 PM
manipulating borders of a table on a per-border basis gib65 Word 3 05-21-2012 12:40 AM
Manipulating Task data from email. dvad Outlook 0 05-10-2011 01:55 PM
manipulating cross-reference fields _wim_ Word 0 12-10-2010 05:52 AM
Manipulating checkboxes in XML Ivo Word 0 12-06-2005 09:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft