Hi, MBeedle,

you could try and protect on opening the workbook or activating the sheet using
Sheets("Test").Protect Password:="PW", UserInterfaceOnly:=True
which won´t allow the users to change anything but enable macros to execute.

Please mind that this is a volatile setting and will not be saved with the workbook.

Ciao,
Holger