ExcelBanter - Enable Macro on open

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Enable Macro on open (https://www.excelbanter.com/excel-programming/415964-enable-macro-open.html)

Lime

Enable Macro on open

Is the a code to enable macros when the file is opened, rather that having to
click enable macro? any help appreciated..
Thanks...

Heera

Enable Macro on open

Hi,

Go in Tools, Macro, Security

In the security level tab select low.

Reopen the workbook and it will not ask you to enable the macro.

Regards

Heera

Lime

Enable Macro on open

Thanks... Seems simple enough..

"Heera" wrote:

Hi,

Go in Tools, Macro, Security

In the security level tab select low.

Reopen the workbook and it will not ask you to enable the macro.

Regards

Heera

Gord Dibben

Enable Macro on open

And leaves you vulnerable to malicious code.

Gord Dibben MS Excel MVP

On Fri, 22 Aug 2008 05:35:01 -0700, Lime
wrote:

Thanks... Seems simple enough..

"Heera" wrote:

Hi,

Go in Tools, Macro, Security

In the security level tab select low.

Reopen the workbook and it will not ask you to enable the macro.

Regards

Heera

All times are GMT +1. The time now is 08:41 AM.