Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to get this going
And it works fine, Except after running And editing a comment (after clicking outside the Comment box the Comment Box is still selected or at least Displayed. I have to NOW - at the menu click on View Comments to turn the display (of it) off. What can I do (within the Macro) to achieve this? TIA, Sub EditComment() 'method suggested by Jon Peltier 2006-03-04 'adds text at end of existing comment text Dim cmt As Comment Set cmt = ActiveCell.Comment If cmt Is Nothing Then Exit Sub End If 'type to add comment text to selected shape cmt.Visible = True cmt.Shape.Select << the Box comes up and I edit my comment End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet has to set to visible as it is not visible after saving and closing Excel by VB. | Excel Programming | |||
Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) | |||
Toggle text to be visible and not visible | Excel Programming | |||
Toggle Text to be visible and Not visible | Excel Programming | |||
Toggle Text in a column to be visible or not visible | Excel Programming |