Enable Macro after Say no on open

[danial]

I need to know that Excel Program will allow user enable macro after click disable on open file.

Normaly on open excel which contain macro. the excel program will alert user to decision enable or disable macro.

Incase click disable macro and use excel ...
after that I want to run macro but I don't want to re-open file

how can do this?

thanks
Danial

 

[Richard Schollar]

Hi Danial

As far as I know you can't subsequently enable macros once you have clicked to disable them - unless, as you have pointed out, you close and re-open the workbook.