Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How could the sub below be amended so that when the activecell is changed to
another via the arrow keys, the comment which was displayed (in the previous activecell) is hidden again (like mousing over). Currently it stays displayed. Thanks Private Sub Worksheet_SelectionChange(ByVal Target As Range) ' GS Dim cmt As Comment Set cmt = Target.Comment If cmt Is Nothing Then Exit Sub End If Target.Comment.Visible = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 / Hide Comment / How? | Excel Discussion (Misc queries) | |||
How do I hide the comment indicators on a web page? | Excel Discussion (Misc queries) | |||
Need to Change ActiveCell | Excel Programming | |||
Amend code or change it completely? | Excel Programming | |||
code to change activecell | Excel Programming |