Sort Functions are Disabled When Sheet is Protected, and more Issue When Sheet is Shared

I'm almost done with a really critical excel sheet that would be shared with different users to update frequently. I'm using some VBA which I believe trigger the problems.

Two issues I'm facing now:

1) Once the sheet is in protection mode, the sort functions within the sheet are automatically disabled even that I do enable them during protecting process. I have not sound a solution for this.

2) when the excel sheet is shared, and the user do anything with Macro functions, this error massage appears and the functions are not working anymore.

run time error 1004 - unprotect method of worksheet class failed

See attached sheet
Vendor RegistrationTracking.xlsm


VBA Code:

Please Login or Register  to view this content.

Please help!

Originally Posted by hulpeloos

Well your are clearly familiar with VB , something often not remembered is using "UserInterFaceOnly:=True" this way its protected against users but allows macro's to change cells.

just an example on how to use it

Please Login or Register  to view this content.

End Sub

Unfortunately I'm not THAT familiar, all these codes are copied from other posts and slightly modified.

I tried to add your code in my worksheet but it did not work. I did not do any modifications expect for the password and it did not help.

can you tell me more about it and what i should expect if it worked? would I be able to share it without issues or would I be able to use the sort function?

Originally Posted by hulpeloos

Ali....first tip is to check your properties before uploading a file.

attached is your file with an extra sheet having a button
this button has now protected your file with the password , details are in module4
let me know if your file is functioning as wanted when being protected.

Yes it does!. I'll study your code to better understand the changes.

Thank you Hulpeloos