We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Pop-Up Msg Box for Word Document

High Priority
24 Views
Last Modified: 2020-06-23
My Word document is a form with simple controls.  I want to remind people to make a copy of it before filling it out.

Is there a way to create a pop-up message box that executes when a Word document is opened from an Office 365 Sharepoint directory?

I tried a simple module with code I found online but it doesn't pop-up when the document opens.  Instead I get assorted warnings about checking out the document to edit and checking it back in.
Comment
Watch Question

Ryan ChongSoftware Tead Lead / Business Analyst / System Analyst / Data Engineer
CERTIFIED EXPERT

Commented:
Is there a way to create a pop-up message box that executes when a Word document is opened from an Office 365 Sharepoint directory?

That is possible when you have the macro enabled word document (.docm)
CERTIFIED EXPERT

Commented:
My Word document is a form with simple controls.  I want to remind people to make a copy of it before filling it out. 
May I suggest to actually create the copy in code instead of just displaying a reminder. This code will create a copy of the open document which can then befilled put and saved.
Sub CreateCopyOfActiveDocument()
    Application.Documents.Add ActiveDocument.FullName
End Sub
Consulting
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Hi Ryan,

Thank you for your reply.  I did save the form as  .docm.

Author

Commented:
Hi Joe,
:-O it didn't even occur to me.  Not sure I can pull it off, but I love the idea.  I'll try your code and see what happens.  Thank you!

Author

Commented:
Hi Fabrice,

I started out saving it as a template but after I added a module I was prompted to change to a macro enabled file type.

I didn't know that template's automatically prompted the user to save a copy.  That might be the easiest solution.

I'll have to experiment with it and see what it can do.

Thank you!

Author

Commented:
After spending hours trying to get a single line of code to work on my template, I'm throwing in the towel.  I can not get a custom message box nor a file save working automatically when the template opens a new document. Neither will anything work when I save it as a macro enabled file as opposed to a macro enabled template.

I'm going to leave it as a simple template file and hope users are smart enough to change the file name when the save as dialogue prompts them.

Frabice gave me the answer I'm ultimately using.  Simply because I'd never noticed a template file opened a new document.  I don't work with Word much, mostly with Excel and Access and apparently there is a difference.

Thank you to all of you who responded.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.