Don't open or use workbook unless macros are turned on?

Hello,

Is there a way to prevent a workbook from opening unless macros are allowed?

Thanks,

Nick

In a word, no.

You can approximate it as follows:

Make all sheets except a splash-screen sheet VeryHidden. If the user doesn't enable macros, all the user will see is the splash screen. If macros are enabled, code makes the user jump through whatever security hoops are required before unhiding selected sheets.

In the beforeSave event, all sheets except the splash screen are re-hidden, the file is saved, and the current environment is restored following the save.

Protect the VBA project.