Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert, position, and resize a picture w/ Macro
I'm completely out of my league here. I can do most basic functions when
dealing with macros, but I need to insert a picture to a specific place in a document. Then, I need to resize it down to half the current size of the picture. Can anyone help me figure out how to get a macro to do that in Excel 2003? Thanks! John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert, position, and resize a picture w/ Macro
You can try this
you see it will make the picture the same size as the cell now. If you know how gig you want it you can fill in the width and height in the code Sub Test() Dim myPict As Picture With ActiveSheet.Range("C1") Set myPict = .Parent.Pictures.Insert("C:\ron.png") myPict.Top = .Top myPict.Width = .Width myPict.Height = .Height myPict.Left = .Left myPict.Placement = xlMoveAndSize End With End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "John" wrote in message ... I'm completely out of my league here. I can do most basic functions when dealing with macros, but I need to insert a picture to a specific place in a document. Then, I need to resize it down to half the current size of the picture. Can anyone help me figure out how to get a macro to do that in Excel 2003? Thanks! John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
How to keep picture position for different versions of Excel? | Excel Discussion (Misc queries) | |||
insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) | |||
Set up menu to resize picture upon right click | Excel Discussion (Misc queries) | |||
Position Picture with macro | Setting up and Configuration of Excel |