In a sheet i have several macro's to lock or unlock a sheet/line/cell.
For example:
Is there a way to place a PW somewhere and to call it. So when i want to change the PW there is one place to change it.shp.Unprotect Password:="Secret" LR = shp.Cells(Rows.Count, 2).End(xlUp).Row LC = shp.Cells(5, Columns.Count).End(xlToLeft).Column shp.ListObjects("PKB").Resize Range("$B$5", Cells(LR, LC)) shp.Protect Password:="Secret", UserInterFaceOnly:=True
Bookmarks