Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to change the style of a cell with a comment .
Here's a link to a similar question/thread:
http://google.com/groups?threadm=105...ttica.n et.nz There's a line in the macro that looks like this: ..Placement = xlMove Add this right below it so that it looks like: ..Placement = xlMove ..PrintObject = False If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm EXCEL$B!!(BNEWS wrote: hi, glad to have the chance to make friends with you via this forum. here is my problem. as you know, when you add a comment to a cell,a red corner will appear to show that there is a comment there. i am puzzled as to how to change the red corner, how to make to be some other colors , or some other shapes instead of red or triangle. and furthermore how i can make an image of my own style like the red corner i mentioned above. i mean to make how to make a cell look like diffirent from other cells , without coloring it or making the word in the cell in a special style.for i dont want it to be printed out. thank you youngman -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Change to Comment | Excel Worksheet Functions | |||
display comment on cell change | Excel Discussion (Misc queries) | |||
How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
I want to change comment printing cell 3 to whats in cell 3 | Excel Worksheet Functions | |||
Change GETPIVOTDATA cell reference to A1 style | Excel Worksheet Functions |