To: Bob Phillips

[Metallo]

Bob,
I was too much enthusiasts this morning when I wrote you that the code is
working, well it does but...

I discovered that it only works if I enable the Macros, otherwise it does
not.

Do you have any solution in mind to help?

Thank you

Alex

 

[Dave Peterson]

I'm not Bob, but I bet he would ask you to stay in the same thread.

And if macros aren't enabled, then macros can't run.

 

[Metallo]

Thanks Dave,

I thought a Macro was something independent from a workbook_Open event.
The macro I have recorderd does only some formatting stuff and it is in the
module, while the code Bob developed is in the workbook and it is activated
on demand.
Although I still don't understand the connection between the two, hence, why
the macro has got an influence on the workbook_Open event, it means that I
have to inform the users to always enable the macro.
True?

Thank you
Alex

 

[Tom Ogilvy]

Yes, macros must be enabled for macros to run.

--
Regards,
Tom Ogilvy

Thanks Dave,

I thought a Macro was something independent from a workbook_Open event.
The macro I have recorderd does only some formatting stuff and it is in the
module, while the code Bob developed is in the workbook and it is activated
on demand.
Although I still don't understand the connection between the two, hence, why
the macro has got an influence on the workbook_Open event, it means that I
have to inform the users to always enable the macro.
True?

Thank you
Alex