Popup userform only for the first time save

R

Raman

I am trying to add different classifcation levels (confidential, restricted,
public etc. )to the word documents in the footer. I have created a userform
from where the user can select the classification level. This userform is
popped up at the time of clicking save or saveas.

I want this userform to pop up only at the time of first save not during the
subsequent saves. Is this possible?
 
G

Graham Mayor

Check the document path length to see if the document has been saved
previously before popping up the form.

If Len(ActiveDocument.Path) = 0 Then
Formname.Show
End If

If the path has a length greater than 0 the document has been saved and the
form will not be displayed.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
R

Raman

Thanks Graham. Much Appreciated.

Regards,
Raman

Graham Mayor said:
Check the document path length to see if the document has been saved
previously before popping up the form.

If Len(ActiveDocument.Path) = 0 Then
Formname.Show
End If

If the path has a length greater than 0 the document has been saved and the
form will not be displayed.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top