Hi All
Hope someone can help me...
I have an autoshape on an sheet, and use this code (it's a circle), to rezise it....
However, it does rezise it, but the shape doesn't keep it's central position. Is there a bit of code I can add to stop the shape from moving? In other words, have the shape rezise around it's center of location?
Please Login or Register to view this content.
Many thanks for any help!
Last edited by Broobi; 07-10-2014 at 12:05 PM.
I think you'll need to alter the left and top also, so left = current left-(new width/2) and the same for the top
I think
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Hi nathansav.
Thanks for your reply.
I see, do you mean, width 'divided' by 2?
also, how do I determine the current left?
Ma
Yes, think so
so if youre moving from 40 to 60 it willand .top is the other.Please Login or Register to view this content.
Perfect! - Thank you so much :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks