S Oberlander
Board Regular
- Joined
- Nov 25, 2020
- Messages
- 147
- Office Version
- 365
- Platform
- Windows
My code is simple, I know the names of my comment shape so I just did:
But the cells that contained the comments still have that little red triangle indicating a comment even though there is none.
How can I get rid of that triangle?
VBA Code:
With ActiveSheet
.Shapes("Comment 1").Delete
.Shapes("Comment 2").Delete
.Shapes("Comment 4").Delete
End With
How can I get rid of that triangle?