| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel, how do I set up default comment containing picture?
I've tried right-clicking on the comment & selecting "set auto shape
defaults, to no avail. Is it possible to set up a default comment, containing a picture, to save having to edit every comment? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel, how do I set up default comment containing picture?
Maybe you could just create your default comment once, then
edit|copy edit|paste special|Comments whenever you need that special comment. pjk@boro wrote: I've tried right-clicking on the comment & selecting "set auto shape defaults, to no avail. Is it possible to set up a default comment, containing a picture, to save having to edit every comment? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel, how do I set up default comment containing picture?
Thanks for the suggestion Dave, that's what I currently do. I suppose I'm
just being lazy wanting the system to do it for me. "Dave Peterson" wrote: Maybe you could just create your default comment once, then edit|copy edit|paste special|Comments whenever you need that special comment. pjk@boro wrote: I've tried right-clicking on the comment & selecting "set auto shape defaults, to no avail. Is it possible to set up a default comment, containing a picture, to save having to edit every comment? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel, how do I set up default comment containing picture?
You could always put a comment in your personal.xls (sheet1?), then use a macro
to copy|paste that comment. pjk@boro wrote: Thanks for the suggestion Dave, that's what I currently do. I suppose I'm just being lazy wanting the system to do it for me. "Dave Peterson" wrote: Maybe you could just create your default comment once, then edit|copy edit|paste special|Comments whenever you need that special comment. pjk@boro wrote: I've tried right-clicking on the comment & selecting "set auto shape defaults, to no avail. Is it possible to set up a default comment, containing a picture, to save having to edit every comment? -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel, how do I set up default comment containing picture?
I tried that a while ago & it didn't work. I can't remember what the problem
was, now. I'll give it another go. thanks very much anyway. "Dave Peterson" wrote: You could always put a comment in your personal.xls (sheet1?), then use a macro to copy|paste that comment. pjk@boro wrote: Thanks for the suggestion Dave, that's what I currently do. I suppose I'm just being lazy wanting the system to do it for me. "Dave Peterson" wrote: Maybe you could just create your default comment once, then edit|copy edit|paste special|Comments whenever you need that special comment. pjk@boro wrote: I've tried right-clicking on the comment & selecting "set auto shape defaults, to no avail. Is it possible to set up a default comment, containing a picture, to save having to edit every comment? -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel, how do I set up default comment containing picture?
Or you could record a macro while you add the comment with a picture,
and run that when you need it. Put the code in a workbook that's always open, and add a button to one of your toolbars, to run the macro. Then, select a cell and click the button. pjk@boro wrote: I tried that a while ago & it didn't work. I can't remember what the problem was, now. I'll give it another go. thanks very much anyway. "Dave Peterson" wrote: You could always put a comment in your personal.xls (sheet1?), then use a macro to copy|paste that comment. pjk@boro wrote: Thanks for the suggestion Dave, that's what I currently do. I suppose I'm just being lazy wanting the system to do it for me. "Dave Peterson" wrote: Maybe you could just create your default comment once, then edit|copy edit|paste special|Comments whenever you need that special comment. pjk@boro wrote: I've tried right-clicking on the comment & selecting "set auto shape defaults, to no avail. Is it possible to set up a default comment, containing a picture, to save having to edit every comment? -- Dave Peterson -- Dave Peterson -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel, how do I set up default comment containing picture?
I've just tried that but got the message, "Run-time error '438'. Object
doesn't support this property or method. "Debra Dalgleish" wrote: Or you could record a macro while you add the comment with a picture, and run that when you need it. Put the code in a workbook that's always open, and add a button to one of your toolbars, to run the macro. Then, select a cell and click the button. pjk@boro wrote: I tried that a while ago & it didn't work. I can't remember what the problem was, now. I'll give it another go. thanks very much anyway. "Dave Peterson" wrote: You could always put a comment in your personal.xls (sheet1?), then use a macro to copy|paste that comment. pjk@boro wrote: Thanks for the suggestion Dave, that's what I currently do. I suppose I'm just being lazy wanting the system to do it for me. "Dave Peterson" wrote: Maybe you could just create your default comment once, then edit|copy edit|paste special|Comments whenever you need that special comment. pjk@boro wrote: I've tried right-clicking on the comment & selecting "set auto shape defaults, to no avail. Is it possible to set up a default comment, containing a picture, to save having to edit every comment? -- Dave Peterson -- Dave Peterson -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel, how do I set up default comment containing picture?
The following code adds a comment with a picture in the c:\Data folder.
You could change that to the path and name of your picture. '========================== Sub CommentAddPic() 'adds formatted comment with picture Dim cmt As Comment Set cmt = ActiveCell.Comment If cmt Is Nothing Then ActiveCell.AddComment Text:="" Set cmt = ActiveCell.Comment With cmt.Shape.TextFrame.Characters.Font .Bold = False .ColorIndex = 0 End With cmt.Shape.Fill.UserPicture "C:\Data\TestPic.jpg" End If End Sub '========================== pjk@boro wrote: I've just tried that but got the message, "Run-time error '438'. Object doesn't support this property or method. "Debra Dalgleish" wrote: Or you could record a macro while you add the comment with a picture, and run that when you need it. Put the code in a workbook that's always open, and add a button to one of your toolbars, to run the macro. Then, select a cell and click the button. pjk@boro wrote: I tried that a while ago & it didn't work. I can't remember what the problem was, now. I'll give it another go. thanks very much anyway. "Dave Peterson" wrote: You could always put a comment in your personal.xls (sheet1?), then use a macro to copy|paste that comment. pjk@boro wrote: Thanks for the suggestion Dave, that's what I currently do. I suppose I'm just being lazy wanting the system to do it for me. "Dave Peterson" wrote: Maybe you could just create your default comment once, then edit|copy edit|paste special|Comments whenever you need that special comment. pjk@boro wrote: I've tried right-clicking on the comment & selecting "set auto shape defaults, to no avail. Is it possible to set up a default comment, containing a picture, to save having to edit every comment? -- Dave Peterson -- Dave Peterson -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel, how do I set up default comment containing picture?
Debra,
I've copied your formula but when I try to run it, the apostrophe above the line "Sub CommentAddPic()" is highlighted & I get the message "Compile error Expected End Sub". "Debra Dalgleish" wrote: The following code adds a comment with a picture in the c:\Data folder. You could change that to the path and name of your picture. '========================== Sub CommentAddPic() 'adds formatted comment with picture Dim cmt As Comment Set cmt = ActiveCell.Comment If cmt Is Nothing Then ActiveCell.AddComment Text:="" Set cmt = ActiveCell.Comment With cmt.Shape.TextFrame.Characters.Font .Bold = False .ColorIndex = 0 End With cmt.Shape.Fill.UserPicture "C:\Data\TestPic.jpg" End If End Sub '========================== pjk@boro wrote: I've just tried that but got the message, "Run-time error '438'. Object doesn't support this property or method. "Debra Dalgleish" wrote: Or you could record a macro while you add the comment with a picture, and run that when you need it. Put the code in a workbook that's always open, and add a button to one of your toolbars, to run the macro. Then, select a cell and click the button. pjk@boro wrote: I tried that a while ago & it didn't work. I can't remember what the problem was, now. I'll give it another go. thanks very much anyway. "Dave Peterson" wrote: You could always put a comment in your personal.xls (sheet1?), then use a macro to copy|paste that comment. pjk@boro wrote: Thanks for the suggestion Dave, that's what I currently do. I suppose I'm just being lazy wanting the system to do it for me. "Dave Peterson" wrote: Maybe you could just create your default comment once, then edit|copy edit|paste special|Comments whenever you need that special comment. pjk@boro wrote: I've tried right-clicking on the comment & selecting "set auto shape defaults, to no avail. Is it possible to set up a default comment, containing a picture, to save having to edit every comment? -- Dave Peterson -- Dave Peterson -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel, how do I set up default comment containing picture?
I think you pasted Debra's code into the middle of another procedure.
Remove that pasted code and add it to the bottom of the module--or put it in a different module??? pjk@boro wrote: Debra, I've copied your formula but when I try to run it, the apostrophe above the line "Sub CommentAddPic()" is highlighted & I get the message "Compile error Expected End Sub". "Debra Dalgleish" wrote: The following code adds a comment with a picture in the c:\Data folder. You could change that to the path and name of your picture. '========================== Sub CommentAddPic() 'adds formatted comment with picture Dim cmt As Comment Set cmt = ActiveCell.Comment If cmt Is Nothing Then ActiveCell.AddComment Text:="" Set cmt = ActiveCell.Comment With cmt.Shape.TextFrame.Characters.Font .Bold = False .ColorIndex = 0 End With cmt.Shape.Fill.UserPicture "C:\Data\TestPic.jpg" End If End Sub '========================== pjk@boro wrote: I've just tried that but got the message, "Run-time error '438'. Object doesn't support this property or method. "Debra Dalgleish" wrote: Or you could record a macro while you add the comment with a picture, and run that when you need it. Put the code in a workbook that's always open, and add a button to one of your toolbars, to run the macro. Then, select a cell and click the button. pjk@boro wrote: I tried that a while ago & it didn't work. I can't remember what the problem was, now. I'll give it another go. thanks very much anyway. "Dave Peterson" wrote: You could always put a comment in your personal.xls (sheet1?), then use a macro to copy|paste that comment. pjk@boro wrote: Thanks for the suggestion Dave, that's what I currently do. I suppose I'm just being lazy wanting the system to do it for me. "Dave Peterson" wrote: Maybe you could just create your default comment once, then edit|copy edit|paste special|Comments whenever you need that special comment. pjk@boro wrote: I've tried right-clicking on the comment & selecting "set auto shape defaults, to no avail. Is it possible to set up a default comment, containing a picture, to save having to edit every comment? -- Dave Peterson -- Dave Peterson -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel, how do I set up default comment containing picture?
Debra/Dave,
Between you, you've made an old man very happy. thank you both. Peter "Dave Peterson" wrote: I think you pasted Debra's code into the middle of another procedure. Remove that pasted code and add it to the bottom of the module--or put it in a different module??? pjk@boro wrote: Debra, I've copied your formula but when I try to run it, the apostrophe above the line "Sub CommentAddPic()" is highlighted & I get the message "Compile error Expected End Sub". "Debra Dalgleish" wrote: The following code adds a comment with a picture in the c:\Data folder. You could change that to the path and name of your picture. '========================== Sub CommentAddPic() 'adds formatted comment with picture Dim cmt As Comment Set cmt = ActiveCell.Comment If cmt Is Nothing Then ActiveCell.AddComment Text:="" Set cmt = ActiveCell.Comment With cmt.Shape.TextFrame.Characters.Font .Bold = False .ColorIndex = 0 End With cmt.Shape.Fill.UserPicture "C:\Data\TestPic.jpg" End If End Sub '========================== pjk@boro wrote: I've just tried that but got the message, "Run-time error '438'. Object doesn't support this property or method. "Debra Dalgleish" wrote: Or you could record a macro while you add the comment with a picture, and run that when you need it. Put the code in a workbook that's always open, and add a button to one of your toolbars, to run the macro. Then, select a cell and click the button. pjk@boro wrote: I tried that a while ago & it didn't work. I can't remember what the problem was, now. I'll give it another go. thanks very much anyway. "Dave Peterson" wrote: You could always put a comment in your personal.xls (sheet1?), then use a macro to copy|paste that comment. pjk@boro wrote: Thanks for the suggestion Dave, that's what I currently do. I suppose I'm just being lazy wanting the system to do it for me. "Dave Peterson" wrote: Maybe you could just create your default comment once, then edit|copy edit|paste special|Comments whenever you need that special comment. pjk@boro wrote: I've tried right-clicking on the comment & selecting "set auto shape defaults, to no avail. Is it possible to set up a default comment, containing a picture, to save having to edit every comment? -- Dave Peterson -- Dave Peterson -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) | |||
| How do I insert a picture within an Excel comment box? | Excel Discussion (Misc queries) | |||
| How do I insert a picture in an Excel comment block | Excel Worksheet Functions | |||
| EXCEL: Is there a way to insert a picture into a comment? | Excel Worksheet Functions | |||
Linear Mode
