I can only presume that the programers thought it simpler and more user friendly if the userform is automatically visible to all users all the time, requireing them only to close the form if it is not needed. While I can easily add macros to my QAT (for example, to open the userform when needed)...
Yes, the form is poorly designed. The Word documents (containing the form and related VBA code) are created by a document management system and I have no control over the form design or VBA code on these documents. The only thing I can hope to do is to add some code to the Normal template to...
This was one of the things I was trying to automate. The Word document automatically pops up the userform whenever the document is opened, using an AutoOpen macro on the Document. The user often does not want to use the user form and must click on the cancel button to close/hide it for the work...
Said another way, my macro would (1) open the fPointLinks form, (2) mimic the selection of a radio button option, (3) mimic the clicking on the OK button on the form, (4) and close/hide the form.
I tried to keep my question simple figuring that if I can learn how to manipulate a fPointLinks form from a macro on the Normal template (such as closing or hiding it), I am on my way to figuring out out how manipulate the form in other ways. Perhaps a fuller expanation is better.
This is the...
I am trying to write a macro that that will close a form (fPointLinks) that displays automatically whenever certain Word documents are opened. I can not change the code in the Word document that contains the VBA form (becasue the document is created by others), so I must create my own macro on...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.