Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 87
Default Specify Image Location?

I received a great help in resizing my images with macros earlier
(POST=INVOLVED - I Suck With User Forms), but now I am wondering if I can
specify the location of the images I am working with?

Basically, what I am doing is using a macro to take an image and resize it
from 100% to either 20%, 45%, or 65%. It looks like the default is to be
anchored to the top left and expand or contract from the bottom right.

However, because this is on a reporting dashboard, there are times I would
want to reverse this... For example on any items at the right side of my
page/viewing window. If they expand as normal, they are outside the report
window.

Of course, I notice that if I click and drag an object to the left to expand
it, the "anchor" moves left as well... This is not the desired result. I
would want the "anchor" to remain in place, but simply specify which
direction to magnify the image in.

I hope this makes sense... Thanks for your help.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there any way to search image of my local drive with Image name or Image Title, Description [email protected] Excel Programming 3 August 3rd 07 01:44 PM
How to copy an image object to new location in shame sheet, Excel. Asko Telinen Excel Programming 3 March 18th 07 10:37 AM
VBA to display image on a form - image is defined in Range Name Tan Excel Programming 4 May 17th 06 03:37 PM
Hyperlink to a location on worksheet and display full image. twilliams Excel Discussion (Misc queries) 1 February 7th 06 10:06 PM
Export the worksheet background image as an image file - possible? DataFreakFromUtah Excel Programming 2 April 10th 04 04:49 PM


All times are GMT +1. The time now is 03:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"