Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-24-2012, 04:23 AM
macropod's Avatar
macropod macropod is offline macro to format this Windows 7 64bit macro to format this Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,514
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

Hi ubns,

You really don't need a macro for this. Once you've made all the stars the same size (eg 0.5cm*0.5cm), position the left & right ones where you want them in each cell (eg 0 and 3cm, respectively) then, for a given cell, select all the stars, set the top positioning to the same value (eg 0 from paragraph), then use the 'align' option to evenly distribute the stars horizontally. Once you're done, it might be a good idea to group the stars in each cell. Amongst other things, that makes it quite easy to copy & paste a set of stars to another location.

Indeed, trying to have a macro locate and re-position the stars after they've already been inserted is problematic - far better to have a macro do the insertion, etc, from the outset.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to find text in between two characters and then format selected text? qcom Word 5 02-19-2015 11:23 PM
macro to format this Need a macro to convert all graphics to GIF format sleake Word VBA 3 02-10-2012 05:00 PM
How do I assign a macro to a button when the macro is in my personal workbook? foolios Excel Programming 2 07-27-2011 02:41 PM
hover format ldecola Word 0 03-09-2011 10:28 AM
Format a Row Eagle710 Excel 0 08-05-2009 08:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:27 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