Force enable macros (hiding sheets is not enough)

Hi guys,

I have an excel spreadsheet that requires macros to be enabled to work properly. I'm looking for a way to force users to enable macros in order to use the spreadsheet. Looking online, I see plenty of articles with the same approach, basically consisting of hiding all tabs and unhiding them via a macro once macros are activated (and hiding them again when workbook closes). My question to that approach is: what prevents the user from first opening the spreadsheet, activating the macros (hence unhiding all the sheets) then [break] macros and save the file like that. If you save and close the spreadsheet while the code is on break, the sheets won't be automatically hidden at close so we're back to square 1, aren't we? Am I missing something here?

Is there a better approach? The same way you have events such as beforedoubleclick, beforeleftclick, etc, is there a way to run a macro before the break button is clicked?

Overall, I would like to find a way for my spreadsheet not to be used when macros are not activated.

Thanks a lot,