I have created a message box that automatically runs when a new document is opened based on a template:
' Display a pop-up message
Sub AutoNew()
MsgBox "UPDATE Page numbering if:" & vbCrLf & "" & vbCrLf & "Additional pages are added" & vbCrLf & "" & vbCrLf & "and/or" & vbCrLf & "" & vbCrLf & _
"Probation and/or Sex Offender case.", vbExclamation + vbOKOnly, "REMINDER!"
MsgBox "UPDATE ""Schedule Of Payments"" if special payment terms are ordered.", vbOKOnly, "REMINDER!"
MsgBox "UPDATE page headers if additional pages are added.", vbOKOnly, "REMINDER!"
End Sub
We have several office personnel that use templates stored on our network. The message boxes execute upon opening a new document, however, if that new document is still open and another new document is opened based on the same template is opened, the macro does not run.
Is there a solution for this?
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…