Remove Enable/Disable Macro message at startup

[carvil16]

I hope someone can help.

I have an excel workbook that contains many hidden worksheets. There
is one unhidden worksheet, on which there are individual items listed.
Whenever a person choose an item, the will have to put in a password.
The password will determine
which worksheet is opened.

Problem: Whenever I try to open the workbook, the messagebox appear
asking if I want to enable/disable macros.

Solution foreseen: I want to use some code to enable the macro even
without the person seeing this messagebox. I also want to use some
code to disable the macro whenever the person close the workbook.

How to perform solution : ???

Can anyone assist me with this?

Thanks much.

 

[Jim Rech]

I want to use some code to enable the macro even without the person
seeing this messagebox

That's not possible. The point is to protect users from "malicious code".
If an evil doer could force his code to run there would not be any
protection.