Hey I actually found a solution to my question..Tell me if I'm doing this right...Will the fact that i'm temporarily disabling sharing the file for a few seconds cause any issues?
I first de-activated the sharing feature
ActiveWorkbook.UnprotectSharing sharingpassword:="123456"
Then I un-protect my sheet
Worksheets("ALL STAR PPV TRACKER").Unprotect "123456"
Then Add this in the end:
Worksheets("ALL STAR PPV TRACKER").Protect "123456", True, True
ActiveWorkbook.ProtectSharing sharingpassword:="123456"
I also added this to remove all the annoying display alerts I was getting for unsharing and sharing file:
Application.DisplayAlerts = True
at the bigging
and
Application.DisplayAlerts = True
at the end
Bookmarks