Comments locked? 1

[notuserfriendly]

Hi again

I'm having trouble with .ClearComments
It doesn't clear the comments when the sheet is locked.
I've tried to unlock it but still the same problem.

Any ideas?

 

[rmikesmith]

I've tried to unlock it but still the same problem.

By this do you mean you Unprotected the worksheet. If not, try this (then re-Protect after). It works for me.


Regards,
Mike

 

[notuserfriendly]

It doesn't help

 

[rmikesmith]

Perhaps you could post the relevant code.


Mike

 

[notuserfriendly]

ThisWorkbook.Unprotect("pass")
Application.EnableEvents = False
 With Range(ws.Cells(SRow, SCol), ws.Cells(ERow, ECol))
  .ClearFormats
  .ClearComments
  .ClearContents
 End With
Application.EnableEvents = True
ThisWorkbook.Protect("pass")

 

[rmikesmith]

You are Unprotecting & Protecting the Workbook not Worksheet

Check your worksheet protection.


Mike

 

[notuserfriendly]

It helped, thanks