Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show Excel comment on mouseover but not the comment indicator
I have created an excel spreadsheet where all cells in a column of
data contain comments. The comments provide additional information about a customer. For example, the cell value is 'Pizza Hut', and the cell comment contains store #, address, city. Showing a comment on every cell creates a very busy looking spreadsheet. Is there a way to hide the indicators, but the cell comments still popup on mouseover? Thank you John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show Excel comment on mouseover but not the comment indicator
Hello John
Comments will popup when you run a mouse over the cell. If you want a macro to hide all the comments, this one is in the help file. Sub hideComments() Set cmt = ActiveSheet.Comments For Each c In cmt c.Visible = False Next End Sub Hope this helps Peter " wrote: I have created an excel spreadsheet where all cells in a column of data contain comments. The comments provide additional information about a customer. For example, the cell value is 'Pizza Hut', and the cell comment contains store #, address, city. Showing a comment on every cell creates a very busy looking spreadsheet. Is there a way to hide the indicators, but the cell comments still popup on mouseover? Thank you John |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show Excel comment on mouseover but not the comment indicator
I want to hide the comment indicators (the red triangle on the right
of the cell) only. I want the comment to behave like a normal excel comment, only I want to hide the fact that a comment exists in the cell. Thank you for your help! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show Excel comment on mouseover but not the comment indicator
tedious but will work - put a white triangle autoshape over the
comment triangle indicator................ or whatever color your background is (i'm assuming it's white). will hide the comment triangle indicator, making it invisible. the white triangle would have to be sized & placed precisely, so that it doesn't mess up borders or anything else. hth susan On Feb 27, 11:57*am, wrote: I want to hide the comment indicators (the red triangle on the right of the cell) only. * *I want the comment to behave like a normal excel comment, only I want to hide the fact that a comment exists in the cell. Thank you for your help! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show Excel comment on mouseover but not the comment indicator
Adding to Susans idea - Debra Dalgleish shows how to do it with VBA @
http://www.contextures.com/xlcomments03.html#Indicator Hope that this helps Peter "Susan" wrote: tedious but will work - put a white triangle autoshape over the comment triangle indicator................ or whatever color your background is (i'm assuming it's white). will hide the comment triangle indicator, making it invisible. the white triangle would have to be sized & placed precisely, so that it doesn't mess up borders or anything else. hth susan On Feb 27, 11:57 am, wrote: I want to hide the comment indicators (the red triangle on the right of the cell) only. I want the comment to behave like a normal excel comment, only I want to hide the fact that a comment exists in the cell. Thank you for your help! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show Excel comment on mouseover but not the comment indicator
You can also use this power XL software for remove comment in excel files and make excel is easy.
http://www.windowindia.net/power-xl.html |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show Excel comment on mouseover but not the comment indicator
You're maybe looking for this simple solution.
http://www.contextures.com/xlcomment...ml#Alternative |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing comment indicator in Excel 2007 | Excel Discussion (Misc queries) | |||
How can I edit a comment w/o first having to select Show Comment | Excel Discussion (Misc queries) | |||
Ability to change the Excel comment indicator color | Excel Worksheet Functions | |||
I have one missing comment indicator amongst several. How can i c. | Excel Discussion (Misc queries) | |||
Ability to change the Excel comment indicator color | Excel Programming |