Prompting for File Properties loses document focus

[Jeremy W]

Does anyone have any suggestions why my template loses focus from the
document when a macros I've written opens the File Properties dialog
box. T

The macro is:

Sub Document_New()
On Error Resume Next
Application.Run "FileProperties"
End Sub

Basically, when you create a new document from the template, the file
properties dialog box opens. If you then close it, then focus goes to
any other program except the new document (or so it seems). It doesn't
seem very impressive, especially as I want all work group templates to
auto prompt for properties in this way.

Many thanks for your interest and help.

Jeremy

 

[Graham Mayor]

You would do better with a vba question in a vba newsgroup.
You can force the doc properties box on save from tools > options > save >
prompt for document properties.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>