Enable/disable macros via vba

[papaandy]

How can i enable macros when the workbook opens and disable them them when workbook closes via vba? Your time and help is appreciated.
Thank you

 

[dave3009]

Hi and welcome

You can't enable/disable macros using VBA, what you can do is make your spreadsheet unusable if the user doesn't enable macros.

 

[ISY]

Hello

Want to remove all macros in the spreadsheet?
This can be done better otherwise specify your request

 

[papaandy]

I am using excel 2007. I have this workbook with some worksheets in their containing some macros, like print buttons and other buttons that do specific tasks. Enabling all macros is pretty risky since malicious codes can run. We have to email this work book to our DM every Sunday and everytime he recieves it he has to enable all the macros, close the workbook and reopen it. I have assigned a digital certificate to this workbook but it works only on my computer and not others unless they enable all the macros. Any help is appreciated.
Thank you