Picture size increase/decrease in size using code

Hi, 
Is it possible to have a macro which will blow a picture up when you click 
on it, and then will shrink it again if clicked again, and will work on any 
picture  i.e. only one macro need be written?
Regards
John
0
Utf
12/6/2009 9:38:01 AM
excel.programming 6508 articles. 2 followers. Follow

2 Replies
983 Views

Similar Articles

[PageSpeed] 16

Just thought of something that would probably be better.
Is it possible to click on the picture so that it would open in a new window 
so that you can use the X to close again?
The workbook would have approx 200 pictures, so if at all possible have one 
code that can pick up any picture
Help greatly appreciated. Many thanks
John


"JohnUK" wrote:

> Hi, 
> Is it possible to have a macro which will blow a picture up when you click 
> on it, and then will shrink it again if clicked again, and will work on any 
> picture  i.e. only one macro need be written?
> Regards
> John
0
Utf
12/6/2009 1:28:01 PM
You could use a Userform with a Image on it, and it would be populated by 
the image selected.
However, i feel you would need the Image location(C:\Documents and 
Settings\User\My Documents\My Pictures.Example.jpg) in a cell for this to 
work.


Corey....
"JohnUK" <JohnUK@discussions.microsoft.com> wrote in message 
news:DF7F4178-1C99-4B83-8300-4A34D2472969@microsoft.com...
> Just thought of something that would probably be better.
> Is it possible to click on the picture so that it would open in a new 
> window
> so that you can use the X to close again?
> The workbook would have approx 200 pictures, so if at all possible have 
> one
> code that can pick up any picture
> Help greatly appreciated. Many thanks
> John
>
>
> "JohnUK" wrote:
>
>> Hi,
>> Is it possible to have a macro which will blow a picture up when you 
>> click
>> on it, and then will shrink it again if clicked again, and will work on 
>> any
>> picture  i.e. only one macro need be written?
>> Regards
>> John 


0
Corey
12/6/2009 11:00:55 PM
Reply:

Similar Artilces:

picture is not showing up in Excel
I have a picture that is in an Excel worksheet. I can see the handles and if I move the handles some, the picture will show up. However, it will not show up in print preview at all or page break preview. I can open the same file on another computer and it will show up fine. Any help would be appreciated. thanks. Check Tools -> Options ->General Do you have "Show All" selected for Objects? "cab58" wrote: > I have a picture that is in an Excel worksheet. I can see the handles > and if I move the handles some, the picture will show up. However, it > will...

Folder using audio thumbnail
I have a couple audio folders that have 2 thumbnails for the folders picture and the first pic is the audio file icon, the second picture is the actual .jpg pic in the folder. Why and how can you stop audio files from becoming a folders thumbnail? Also, when I have a band folder going few subfolders the main folder will have multiple thumbnails taken from the subfolders. I've tried to use property's - customize and choose the picture file I want as a single folder thumbnail but nothing changes. I've checked to make sure I had authority over the folder and it's s...

tracking messages using From field
We have serveral distribution lists that we have enabled Send As permissions. Is there a way to track who is sending a certain message when they choose the From: field then enter the distribution list. I also dont see any header information when we send from the same Exchange 2003 server, is there a way to enable this Logging does not get that granular, AFAIK. The only way would be to go around to everyone that has permissions to Send As the DL and check their Sent Items. Internal messages do not contain headers, because the message is submitted via MAPI. -- Ben Winzenz Exchange M...

Adding custom pages to Windows Control Panel using MFC
Hi, Is there anybody know how to add a custom page to Windows Control Panel using MFC? I found some code on Internet but that was written in Win32 API. Also tried to find the material on MSDN but the content is pretty old (if I am correct) : http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarvc/html/msdn_ntcplapp.asp Thanks. Is this what you're looking for? http://www.codeproject.com/shell/cpl.asp Tom <hugheslin@hotmail.com> wrote in message news:1145355183.002746.18420@z34g2000cwc.googlegroups.com... > Hi, > > Is there anybody know how to add a cus...

Size of the 'References:' header
Hi, Is there a way to not add message ids to the 'References' header item when replying to messages, or, at least, when it grows too big ? My ISP SMTP gateway refuses to relay mails when header lines are too long. Exchange 2007 SP1 Thanks Christian ...

Inserting picture from "My Pictures"
When I add a pic from "My pictures" the entire picture does not appear on the slide and when I try to format it it is impossible to get it back to the same pic I am attempting to add. If I am trying to add a pic I might only get a nose or a blade of grass instead of the original picture from "My Pictures". Reduce the zoom to 10%. Coul be a too large image "PP Neophyte" <PP Neophyte@discussions.microsoft.com> a �crit dans le message de news: CA5F97E6-D4D8-401B-B066-E261024F082F@microsoft.com... > When I add a pic from "My pictures" t...

Display data in the form using the tables
Is it possible to Display data in the form using the tables as the back-end database.if so ,please provide me any examples.... thanks in advance. On Thu, 22 Apr 2010 20:42:01 -0700, Chiki <Chiki@discussions.microsoft.com> wrote: >Is it possible to Display data in the form using the tables as the back-end >database.if so ,please provide me any examples.... > >thanks in advance. What do you mean by "using the tables as the back-end database"? Data is always stored in tables. These can be local tables, or can be linked in a backend (which might be a...

Window size suddenly changed!
I have access to everyone's calendar/contacts in the company. The window size when I open up someone's calendar/contacts has suddenly changed. It used to be a normal rectangle. Now, it's this tall, skinny window that does not really allow me to see the contents. I can't change the view back to how it used to be. It's like this w/ everyone's calendar and contacts (excluding mine). Help! It's so annoying to have to resize the window everytime I open one up. Thanks! ...

How to intercept GP code in Dexterity
I am working through the course material for Dexterity/SanScript and understand that I can "intercept standard GP code" and insert my own procedures. I am a bit unclear on how to "intercept" it. I see that I can use triggers, but how do I know what GP functions or procedures are executing at any given time, so that I know what I'm supposed to intercept, as well as what process(es) I might be interrupting? At this point, I am just learning and do not have a specific task I'm trying to accomplish. I would appreciate all input. Thank you! Mike You can use...

Embedded pictures
Hello! I noticed that the when we set the picture property of a button or another control as embedded, it takes a lot of place. Is there an explication that show why the Access file encrease in size by more than the picture size (even if it is a bitmap, a format that is normaly heavy) Exemple: An mdb without picture would take 4 MB the same file with pictures would increase to 40 MB with only 400 KB of pictures. In JPEG format. Is it because Access uses a non efficient compression to include the image file? Thank you in advance for any suggestion! PS: I know that I can set the pictur...

Dropdown Size: How do I change?
I have a workbook and after opening it on another computer, all the dropdowns are way too wide. And how can I have them show 20 items rather than the default of 8? Thanks, Craig Right-click the dropdown and you can change the 8 to any other number. To make it less wide, right-click it and drag the right/left border to the size you want. It MAY have something to do with the screen resolution on the other computers...? Bob Umlas "Craig Roberts" <Somewhere @ Lindstrom Minnesota USA> wrote in message news:e4jiOnVPFHA.1268@TK2MSFTNGP14.phx.gbl... >I have a workbook a...

Pictures don't print in outlook 2000 or 97
How do I get pictures to print when I print messages for Outlook 2000 or Outlook 97. I'm using XP Home. Thanks, Chris Hi Chris, Have you checked to make sure you have all of the latest Windows and Office Service Packs installed? I remember this issue from a whle back, and it was corrected in one of the service pack releases. Regards, Scott Atkins MCSE, MCSA Partner Technical Lead - Outlook Microsoft Technical Support for Platforms and Business Applications -------------------- >From: socialism001@yahoo.com >Newsgroups: microsoft.public.outlook >Subject: Pictures don't...

Compile Error using Dmax funtion
Can any one help me determine why I'm getting a compile error when using the dmax function? Dim pk As Long The line of code pk = DMax("[OpLogJobDataID]", "tbl_OperatorLogJobData") Do I need to install a reference or add a public function? Any help would be appreciated You need to prefix it with WorksheetFunction. WorksheetFunction.DMax(..., ..., ...) You'll note that the function requires 3 arguments, not 2 as you've supplied. For example: pk = WorksheetFunction.DMax([tbl_OperatorLogJobData], "OpLogJobDataID&quo...

Follwup calls/events without using workflow
I have been asked to post this message, so please excuse me if it turns out to be obvious..... We, well my colugue, is looking at replacing Goldmine with MS CRM and on first impressions is very excited. They are now looking at the way in which we actually work and this has brought up a few questions, most of which we have solved. The problem we are stuck with is follow up calls. We call a prospect who may or may not be there, we may want to reschedule the call, or if they are in and say to call back in a week, again we want to reschedule the call. It does not seem obvious how we are to do...

Command Button Font Changes Size
I have a command button on a worksheet that calls a function. The function simply navigates to a specified cell. After I click the button the button caption's font gets smaller and the button stays "depressed." I created a test button that just opens a message box and it does the same thing. If I go to design mode and resize the button the font restores itself to the original size. I've done a lot of VBA programming, but I've never messed around with Excel forms and controls. What have I overlooked? Thanks, Tom I've never seen this in real life, but thi...

picture in picture
Have to digital pictures & would like to put a couple of people on one picture into the other picture. How do i do this? Anyone got any ideas? TIA "ted medin" <n6trf@arrl.net> wrote in message news:OaNwFXQeKHA.2596@TK2MSFTNGP04.phx.gbl... > Have to digital pictures & would like to put a couple of people on one > picture into the other picture. How do i do this? Anyone got any ideas? > TIA Well not with Vista. You need a Graphic editing application. The Gimp may be able to do this. (It's free, Open Source but is a bit tricky yo get to lear...

Mailbox Size not changing
I'm running Exchange 2003 - Enterprise edition. Recently I discovered that our Mailbox store had grown to a tremendous size since we didn't impose any restrictions on the users. However there came a time when we needed to free up more room on the server so we went ahead and deleted emails from users who had left the firm. The way we did this was by logging in under their name and then going and deleting their emails. By this method, we deleted what seemed like 15 GB worth of emails. However, it seems that this didn't change the actual amount of space available on the hard drive whe...

Picture in Publisher
When inserting pictures in publisher the picture does not show. I can see the frame. The same thing when I load a publisher file created by someone else. All the inserted pictures does not show. View>pictures is set to detailed display. Any suggestions for a solution? -- Thor Read the third FAQ here http://ed.mvps.org/Static.aspx?=Publisher/FAQs -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx "Thor" <Thor@discussions.microsoft.com> wrote in messag...

Sending pictures with text and then another picture with text.
I receive some e-mails with text and then a picture with more text and again a picture. Some of these will have 8 to 10 pictures with text under each picture. But when I send it out it is received with all of the text in a group and the pictures are all sent as attachments. How do I get my e-mails to send the pictures and text the way I receive them? Thanks for any help you can give me. Bob ...

Extend Rows and related formula downwards using functions not macros
I have a simple worksheet to amortise a loan. I would like to use a formula to extend the rows downwards to the number of payments (Number of years x Number of payments per year) using a formula. For example, if there were 26 payments per year over 1 year, there should be 26 rows. Now if I change the number of years to 2 years, two things should happen: 1. The number of rows should expand to 52 from 26 2. The sum of the interest paid should include these extra rows.i.e =Sum(rownumber 1 to row number 52) instead of Sum (rownumber 1 to rownumber 26). Currently I am using a simple formula alon...

How can you tell "To" address used for spam?
I have a few exchange email addresses on my account. Spam level is to the point that I want to delete the affected account. How can I tell which address is being used? Nick You mean you have multiple addresses for the same mailbox? The easiest way to pin-point the address would be the create multiple mailboxes for these addresses. Emails will get sorted for you automatically. -- Alexander Zammit WinDeveloper Software IMF Tune - Unleash the Full Intelligent Message Filter Power http://www.windeveloper.com/imftune/ "Nick" <nickmirro@spamarrest.com> wrote in message...

How do you increase the number of characters in an embedded hyperlink in outlook?
I'm trying to find out how to increase the number characters that can be embedded in a hyperlink in outlook or outlook express. What is happening is that if the hyperlink is too long, the remaining characters are truncated and put on a separate line, not attached to the hyperlink. Clicking on the modified hyperlink gives you an error saying it cannot be found. I found the answer to this years ago and it was a registry modification. Unfortunately, I can't remember where the modification was. Any help would be appreciated. Thanks "black" <blackfox135@...

Using Excel DataBase to do e-mail merge
I'd like to send an e-mail to each person in my excel spreadsheet. How can I do this Outlook e-mail merge. Have you looked at the help files? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Dennis asked: | I'd like to send an e-mail to each person in my excel | spreadsheet. How can I do this Outlook e-mail merge. ...

Picture Link
Appreciate some help here and thanks in advance. I link my pictures to the following folders C:\Documents and Settings\MyName\Desktop\Picture.jpg C:\Documents and Settings\MyName\My Documents\Picture.bmp My code: If Me!pic1a = "X" Then Forms!startpg!fmpPic!Img.Picture = "" Else Forms!startpg!fmpPic!Img.Picture = Me!pic1a End If It works on my PC but when I copied the program to another PC, it does not work. This is because of "MyName" and the other PC has a different name. Is there a way to ignore "MyName" for any PCs Regards "ChoonBoy&quo...

Picture in header
How do I get a picture in the header? This was added in xl2002. File|Page setup|header/footer tab|custom header There's an icon that looks like a picture near the far right. Steve wrote: > > How do I get a picture in the header? -- Dave Peterson If you are using a version of Excel before 2002 then check out: http://www.nwarwick.co.uk/Excel2000GraphicalHeaders.htm for a workaround. HTH Neil www.nwarwick.co.uk "Dave Peterson" wrote: > This was added in xl2002. > > File|Page setup|header/footer tab|custom header > There's an icon that looks lik...