hello all
When i open the file, it probpts for enable/disable. If I say, disable, none of the coding is working. I want to inform the user that if he selects disable macros, the application will close and do the same in action too.

He needs to always select enable macros to access my file.

 Is there a vba code to this job automatically?

The protection wouldn't be of much use if anyone could disable it programmatically.

It should only be the macros/vba environment that's disabled - and only when security is set to the highest level, the user won't get a choice.

One way to give information to the user is to provide a message in a cell in the opening sheet (saved with the workbook), telling him that if he can read this message, the security level have disabled the macros and tell him what to do.

Then, in the Workbook.Open, write code to delete the content of the cell with this message.

I think you should test how this works with the different levels of security.