Microsoft Office Forums - View Single Post - [Solved] Content blocks stop working when changing file path

gorkac · 03-24-2022, 03:15 AM

What I need is that they always open a new document based on the template. Prevent the template from working.
At the moment it has occurred to me, from Document_Open, to launch a message asking them to close the template and reopen it as "New". For them to work the document based on the template.
It is that if they work the template directly, someone will spoil it.

Code:

Sub Document_Open()

'macro message
     MsgBox "CLOSE TEMPLATE, PLEASE REOPEN " _
     & "DOUBLE LEFT-CLICK ON THE TEMPLATE OR, WITH THE RIGHT MOUSE BUTTON, SELECT ''NEW''"
End Sub