Good Day Greg. The code above works wonderfully but I had a quick question. I was informed to implement a new feature in our workbook (I got the other feature working) but it requires this code to have a very small change that I am having issues changing on my own. Essentially when the worksheets are locked again, it needs to leave the option 'Format Columns' checked. This is because the user has an option now that lets them change the column size. All other options can stay locked.

I am pretty sure this part of the code

Call SetWorkbookAndWorkSheetProtection(wbk:=wbk, bProtected:=True)
is what needs altered but I am unsure how to have VBA differentiate what options are locked and which are unlocked. They should only be able to 'select unlocked cells' and 'format columns'. If its a big change then I can definitely just create a new post but I think it could be a relatively simple change.

Thank you for all of your help. Seriously. You have saved my company so much time already its almost unreal.