Force macro enabling to access the workbook

[steve2000]

Hi !

I'm looking for a solution to block a 20.worksheets.workbook acces if the user dont activate is macro first. And after activation then he will see and have acces to the full workbook.. ?

Any solutions ?
Thank you very much and have a great day!
Steve

 

[mole999]

basics are, you build a macro that closes the sheets to xlveryhidden and enable a front sheet that basically says you opened the work book with macros disabled

if macros are working, you hide the warning page and unhide the hidden sheets

lock your vba a project

make sure that just shutting a workbook also forces a save otherwise they might circumvent