Sub yy()
Dim pz, aa
For Each pz In ActiveSheet.Comments
aa = pz.Parent.Address
pz.Visible = True
pz.Shape.Left = Range(aa).Offset(1, 1).Left
pz.Shape.Top = Range(aa).Offset(1, 1).Top
pz.Shape.Height = 50
pz.Shape.Width = 80
Next
End Sub
Sub yy()
Dim pz, aa
For Each pz In ActiveSheet.Comments
aa = pz.Parent.Address
pz.Visible = True
pz.Shape.Left = Range(aa).Offset(1, 1).Left
pz.Shape.Top = Range(aa).Offset(1, 1).Top
pz.Shape.Height = 50
pz.Shape.Width = 80
Next
End Sub