Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-12-2018, 01:33 PM
LimpingBuf LimpingBuf is offline Showing userform in document open results in error message Windows 10 Showing userform in document open results in error message Office 2016
Novice
Showing userform in document open results in error message
 
Join Date: Feb 2007
Posts: 3
LimpingBuf
Default Showing userform in document open results in error message

This should be easy but I can't make it work. I would like to distribute to outside clients templates of various contracts we have created for them. I have created a template (call it the "parent template") that holds a form that populates a list box with the template names and allows the user to select a template and create a new contract based on the selected template.

The form itself works fine when activated from a macro when the parent template is open. However, when I try to open the form using the document open event based in the parent template, I get a message saying:

"You cannot close Microsoft Word because a dialog box is open. Click ok, switch to Word, and then close the dialog box."

Either X'ing out or clicking on ok puts me into the form and everything works fine from that point in.

The other point to be aware of that may be a factor is that after the new document is created, the form is closed and the parent template is closed.

I use a similar system to allow people within my firm to access contract templates and it works quite well. However, in our firm we distribute a parent template that is loaded into word at startup. A macro is installed on the user's toolbar and that activates and shows the selection form. Unlike the client project, our internal project does not close the parent template.

A long winded question, but hopefully that gives you an idea of what I trying to do. I suspect that there is an easy fix, but i can't find it.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Error message when trying to open excel file Glenda Excel 1 08-03-2015 07:12 AM
Showing userform in document open results in error message Error message opening a document in Word "Word cannot open this file because it is larger than 512 M poonamshedge Word 2 09-11-2014 06:11 AM
Change focus from userForm back to word document to see results. Hank Smith Word VBA 1 08-11-2014 05:00 AM
Showing userform in document open results in error message Automation error Unknown error" message once they open the Excel file hlina Excel 1 10-08-2013 09:14 PM
Repair command results in error message srdiamond Office 0 03-01-2011 12:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft