Workbooks can be protected (sheets are locked). Sheets can also be protected (cells are locked). And vba projects can be protected (VBA is locked). But Excel is not inherently secure so don't invest too much time in all of this - all such passwords can be cracked without too much trouble - by anyone with a determination to break your code, anway.
I understand about the passwords being cracked but I just want to prevent "computer challenged" coworkers from messing up a file.
I've got it protected to an extent. I just wanted to know if a change of the options (specifically to the workbook) could be prevented.
I get that the answer is there is no way to do that.
I have unchecked the box to show tabs. I have removed headers and row indicators and I have locked the first tab. This is a tab with instructions of how to use the workbook and its macro, and the other tabs which are used for my macro I have not locked. I don't necessarily want to. That is why I have asked this specific question. Thank you for the assistance.
That sounds like it should do the trick, I guess. Are you not satisfied with the result? I'm not good at "locking down" workbooks because I don't do this myself - better to have something that is intuitive and does the job so well that users want to use your macros just the way they are intended to work. Invest a little bit of time in training. And keep a backup for the unexpected.