| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide all open comments in a particular range
If you only want to make the comments invisible change the code from
rng.Comment.Visible = Not rng.Comment.Visible to rng.Comment.Visible = False TK "tx12345" wrote: That is a nice little piece of code, thanks. But I can't figure out how to make it only toggle off. is there a way to customize the code so it only closes the comments and not opens them? thanks again tx -- tx12345 ------------------------------------------------------------------------ tx12345's Profile: http://www.excelforum.com/member.php...o&userid=24776 View this thread: http://www.excelforum.com/showthread...hreadid=574355 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel | |||
| Display Comments on Each Page | Excel Discussion (Misc queries) | |||
| Array to named range conversion... | Excel Discussion (Misc queries) | |||
| Need open ended cell for Sum range. | Excel Worksheet Functions | |||
| Match function...random search? | Excel Worksheet Functions | |||
Threaded Mode
