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 |
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 |
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! |
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! |
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! |
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 |
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 |
All times are GMT +1. The time now is 09:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com