LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Macro to insert an object in a specific cell 2007`

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
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
INSERT OBJECT BASED ON CELL REFERENCE Gwen's Rose Excel Worksheet Functions 2 August 1st 07 02:32 AM
Macro to insert a object in excel Lester from AUS[_2_] Excel Discussion (Misc queries) 5 March 28th 07 02:47 AM
Cell value becomes filepath to insert picture,jpg or object Rookie_User Excel Worksheet Functions 0 February 6th 07 04:32 PM
macro to insert row after specific text Luke Excel Discussion (Misc queries) 2 September 19th 05 04:06 PM
How do I embed an object into a specific cell in Excel? fish Excel Discussion (Misc queries) 0 June 15th 05 12:16 PM


All times are GMT +1. The time now is 12:25 PM.

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

About Us

"It's about Microsoft Excel"