Hide/Show Comment Shapes on Worksheet

Tech

New member
Joined
Jan 25, 2017
Messages
23
Reaction score
0
Points
0
Excel Version(s)
2010
Hi,

I have this code to hide or show comment shapes on the Transactions sheet. Do the shapes have to somehow be assigned to the 'HelpPopUpsGroup' ?

Thanks for any help

Code:
Sub ShowHelpTransactionsScrn()
If Sheet5.Range("C2").Value = "Show Help" Then
Sheet5.Shapes("HelpPopUpsGrp").Visible = True
Sheet5.Range("C2").Value = "Hide Help"
Else:
Sheet5.Shapes("HelpPopUpsGrp").Visible = False
Sheet5.Range("C2").Value = "Show Help"
End If
End Sub
 
Thanks for telling us, but if you cross-post, you are required to declare it immediately. This rule exists here, on Chandoo and on pretty much all forums.
 
Back
Top