PDA

View Full Version : Macro to Run on Opening



brennaboy
08-16-2010, 04:22 AM
Hi,

Is it possible to do the following:

When a users opens a document, a macro runs straight away automatically to prompt the user to resave the file with a new name and then a userform pops up.

I am going to create a useform to take information from the user and populate the document.

How do you get a macro to run on opening?

Cheers,

B.

fumei
08-16-2010, 09:54 AM
Use the Document_Open event. It must be in the ThisDocument code module.