Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sometimes when we run macro in word, runs in all open docs

Status
Not open for further replies.

pubgal23

Technical User
May 18, 2005
2
US
We have a macro we run (or a few macros) on text when we bring it down off the web, things like change underline to italics, remove extra spaces, that kind of thing. The macros all run fine. However, the boss swears (though we've never seen it) that sometimes when he runs the macros, the macro proceeds to open all word windows and run the macro on them. We only want the macro to run on the "active" window, the file that he is actually working in, but for some reason (and only sometimes) the macro is continuing, it will pull up the next file, bring to the front, and run the macro. Is there any setting or something that is allowing this to happen? is there something we might need to do to the macro so that it doesn't? One of the files he has to have open for his workflow is 5000+ pages and when this macro tries to run through the text again, it takes a lot of time (not to mention the annoying-factor) anyone have any suggestions at all?!
thanks!
 
He could try the "Detect and Repair" option in Help.

You could also look to the MS Office forum for expert help.

Troubleshoot recording and running macros

"If you only want the code (your macros) to apply to one template then the code will be loaded when the template is opened, or a document based on the template is created or opened.


If you want the code to be available to all documents then it means that the template has to be installed as a global addin or the contents copied to Normal.dot (the least preferred method)."


Load or unload a global template or add-in program
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top