Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to put picture in background
Hi all. I'm new to macros. so bear w/ my stupidity
is this even attemptable for a newbie? GOAL: write a macro to put a hard-coded(for now) image into the background of a hard coded(for now) comment TRIED: I recorded the included macro with the following actions: *1 give cell a comment *2 select cell border *3 fill with picture INTUITION SAYS: Range("D59").Comment.Fill.UserPicture _ "C:blahblah" but this gives me an error. is there an intermediate object I need between comment and fill??? the problem with the included one is that it doesnt run.... it seems to jump from range to selection. recording scripts never works :-( Sub Macro1() ' Range("D59").AddComment Range("D59").Comment.Visible = False Range("D59").Comment.Text Text:="USER:" & Chr(10) & "" Selection.ShapeRange.Fill.ForeColor.RGB = RGB(255, 255, 255) Selection.ShapeRange.Fill.Transparency = 0# Selection.ShapeRange.Fill.UserPicture _ "C:\Documents and Settings\Administrator\My Documents\My Pictures\ART#1\1072.jpg" End Sub CHECKED: forums documentation office 2003 SBE |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to put picture in background
Dim Com As Comment Set Com = Range("A1").AddComment Com.Shape.Fill.UserPicture _ "C:\PathToFile\pic.jpg" Set the properties as desired. You do not need to .select most XL object before you work with them. NickHK "puuukeey" wrote in message ... Hi all. I'm new to macros. so bear w/ my stupidity is this even attemptable for a newbie? GOAL: write a macro to put a hard-coded(for now) image into the background of a hard coded(for now) comment TRIED: I recorded the included macro with the following actions: *1 give cell a comment *2 select cell border *3 fill with picture INTUITION SAYS: Range("D59").Comment.Fill.UserPicture _ "C:blahblah" but this gives me an error. is there an intermediate object I need between comment and fill??? the problem with the included one is that it doesnt run.... it seems to jump from range to selection. recording scripts never works :-( Sub Macro1() ' Range("D59").AddComment Range("D59").Comment.Visible = False Range("D59").Comment.Text Text:="USER:" & Chr(10) & "" Selection.ShapeRange.Fill.ForeColor.RGB = RGB(255, 255, 255) Selection.ShapeRange.Fill.Transparency = 0# Selection.ShapeRange.Fill.UserPicture _ "C:\Documents and Settings\Administrator\My Documents\My Pictures\ART#1\1072.jpg" End Sub CHECKED: forums documentation office 2003 SBE |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Background Picture | Excel Worksheet Functions | |||
How do I add a picture to the background? | Excel Worksheet Functions | |||
Background picture behind chart | Charts and Charting in Excel | |||
Excel background picture | New Users to Excel | |||
Background Picture OR text over a picture | Excel Discussion (Misc queries) |