My thread on protecting data validation from being overwritten was solved, for which many thanks. But I now find that it only works if macros are enabled. Company policy is that they must be manually enabled when a workbook is opened. If macros are not enabled, the data validation can still be overwritten by the users, and will be, almost invariably.

So is there a way to not let them work on this workbook until/unless macros are enabled?

Thanks in advance.