GS, you are saying to use the UserInterfaceOnly protection option in the Workbook_Open sub and not having to deal with it inside the
vb code ever again? This is brilliant. I had actually just put the protect code(without UserInterfaceOnly) into that sub yesterday so I didn't have to protect all my sheets before I closed once I had made changes.You learn something new everyday.