I have created a button with the below assigned macro so that when the button is clicked, the whole spreasheet freezes.
This works with the below code but the issue is that anyone can click on the review tab and unprotect sheet. the worksheet will then unlock without requesting the password, whereas it requests the password without the macro.
Is there a way to fix the code so that anyone clicking on "unprotect sheet" will be prompted to enter the password. Any help would be greatly appreciated.! Thanks very much!
Sub ProtectSheet()
ActiveCell.Cells.Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
ActiveSheet.EnableSelection = xlNoSelection
End Sub
Bookmarks