Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to insert an object in a specific cell. i can get it to work in
2003, but not in 2007 does anyone have any insight as to what i am doing wrong....here is the code that i am using Sub test() ' ' test Macro ' Macro recorded 7/7/2008 by mspears ' ' Range("B30").select ActiveSheet.Pictures.Insert("H:\scan0002.jpg").Sel ect Selection.ShapeRange.PictureFormat.TransparentBack ground = msoTrue Selection.ShapeRange.PictureFormat.TransparencyCol or = RGB(253, 253, 253) Selection.ShapeRange.Fill.Visible = msoFalse Application.CommandBars("Picture").Visible = False End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
INSERT OBJECT BASED ON CELL REFERENCE | Excel Worksheet Functions | |||
Macro to insert a object in excel | Excel Discussion (Misc queries) | |||
Cell value becomes filepath to insert picture,jpg or object | Excel Worksheet Functions | |||
macro to insert row after specific text | Excel Discussion (Misc queries) | |||
How do I embed an object into a specific cell in Excel? | Excel Discussion (Misc queries) |