| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide all open comments in a particular range
Hi I have a range of cells on a sheet that have comments the user can make visible. I know how to hide one cells comments: Code: -------------------- Range("a1").Select ActiveCell.Comment.Visible = False -------------------- vut what if there are several comments open in range("a1:a30")? Is there a way to close them all at one time *without* employing the universal command to hide all comments throughout the workbook? Many thanks 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
