i use the following code to lock a sheet individually:
Sheets("Executive Summary").Protect Password:="techedit", UserInterfaceOnly:=True
what is the code to lock all sheet in a workbook using this same idea with a password of "techedit" and userinterfaceonly:=true
hope someone can assist
Sheets("Executive Summary").Protect Password:="techedit", UserInterfaceOnly:=True
what is the code to lock all sheet in a workbook using this same idea with a password of "techedit" and userinterfaceonly:=true
hope someone can assist