Enable Macro when open workbook

[Rungravee Boonsud]

Hi Everyone,

Can I force user for enable macro when open workbook.

because if user disable macros...the macro cannot run

I want to always run macro with this workbook

Anyone have advise this case ?

 

[Tim_Excel_]

As it's a safety measure, there is no straight solution for this. Imagine a malicious code enabling macro's by itself, thereby easily surpassing this defense strategy.

A workaround is to show the user they have to enable macros by showing them a splash screen, as is explained more in detail here.

If you are opening a workbook which itself contains macros with VBA, then you can indeed enable macros via VBA. Take a look at this link, and this other link.

 

[Rungravee Boonsud]

I want to try follow this link

https://www.dummies.com/software/microsoft-office/excel/forcing-your-clients-to-enable-excel-macros/

but i cannot

 

[Tim_Excel_]

What a shame

 

[Steve41553]

The trust centre (File - Options - Trust Centre) allows macros to be enabled automatically when a spreadsheet is opened.To get a macro to auto-run call it Auto_open

 

[Tim_Excel_]

Steve,

This requires a user action which may very well be not preferred. Moreover, this option would enable macros on every succeeding workbook the user will open, if the settings are not reversed beforehand. This is a potential security concern.

 

[Steve41553]

Apologies for the delay. I had to reply from home as the board is often blocked at work.

Yes it can be a risk, but only if you import macros. Mine are all my own work (you can tell that because the coding techniques are so out of date).