I am working on a spreadsheet to track maintenance, it needs to be protected so that none of the formulas or formats are messed up by the users.
Anyway I have this piece of Code that changes the sheet based on a a choice earlier on, and it runs perfectly when the sheet is protected or not...