I have a few worksheets within the same workbook that have protection that protect links and formatted text. There can be times that when a sheet needs to be unprotected to make modification or changes to the sheet, at that point I would right click on sheet name at bottom, and then select unprotect, that’s parts OK. The protection is used to help prevent any BOO BOO’S. Can I use this code below to add protection to sheet, even though sheet is already protected, or do I need to add something. It seems to work OK, I just don’t want it to be an issue later on. And which approach is better to add code at the closing of sheet or opening.
Code: Select all
ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:=True, Password:=""