NeverALegend
New Member
- Joined
- Apr 18, 2017
- Messages
- 1
I have a workbook to which I want to have a beforesave run in which I delete both comments and highlights, I have not been able to achieve it in the last few weeks, I've searched for possible solutions among other co workers, I was suggested the tracking system inside excel but this is a worksheets is based on an excel table. so far I have the following for removing the highlights and it works well, but I would like to include a way to remove the comments as well
Any help is greatly appreciated
Code:
Private Sub Workbook_BeforeSave (ByVal SaveAsUi As Boolean, Cancel As Boolean)
Workbooks("Tracking GB Calculator").Activate
Sheets("Tracking List").Select
Range("C3:C2417").Interior.Color = XlNone
End Sub
Any help is greatly appreciated