Little bit of Excel knowledge is a must thing :
I ran into an issue recently, got mail with all comments not in the right position. Following code snippet helped to survive
ATL+F7 took me to vba
Pasted the following and ran this :-
Sub ResetComments()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Top = cmt.Parent.Top + 5
cmt.Shape.Left = _
cmt.Parent.Offset(0, 1).Left + 5
Next
End Sub
And ofcoz Review tab helped me to hide them later :)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.