This is probably a very simple question, but I don't know the answer! Can
someone please help me?

Where should I place a macro to perform an action as a document opens?

Specifically, I need to open the doc, every time, in print preview.

Thanks in advance for your any help you can give me.
Regards,

There are several ways to run a macro on opening a document. An AutoOpen
macro is probably the easiest. It can go in any module in the document or
its template (ThisDocument if you like) and must be called "AutoOpen". There
are a set of precedence rules if you have more than one but, for this, you
don't really need to worry about that - just have one macro to avoid the
issue.

--
Enjoy,
Tony


"Myriam" wrote in message
...
This is probably a very simple question, but I don't know the answer! Can
someone please help me?

Where should I place a macro to perform an action as a document opens?

Specifically, I need to open the doc, every time, in print preview.

Thanks in advance for your any help you can give me.
Regards,

Thanks for your help. I got it working.
Regards,

"Tony Jollans" wrote:

There are several ways to run a macro on opening a document. An AutoOpen
macro is probably the easiest. It can go in any module in the document or
its template (ThisDocument if you like) and must be called "AutoOpen". There
are a set of precedence rules if you have more than one but, for this, you
don't really need to worry about that - just have one macro to avoid the
issue.

--
Enjoy,
Tony


"Myriam" wrote in message
...
This is probably a very simple question, but I don't know the answer! Can
someone please help me?

Where should I place a macro to perform an action as a document opens?

Specifically, I need to open the doc, every time, in print preview.

Thanks in advance for your any help you can give me.
Regards,