Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |