Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
Photo

Word Macro mysteriously changes active document


  • Please log in to reply

#1
russelljb

russelljb

    New Member

  • Member
  • Pip
  • 1 posts
I have this really straightforward Word macro that displays a VBA form and then changes some of the document properties when you hit OK.

The thing is when you run the macro from a toolbar button on a global template, and there are multiple documents open, the active document switches to the first active window loaded.

So, if you open Word with a doco hello.doc and then you add a new Document2 which has the focus, when you run the macro on Document2 it disappears behind hello.doc.

The macro actually changes the correct document (Document2 in this example), but it looks confusing to see the document that the macro affects, being hidden.

Stepping thru the macro shows the ActiveDocument does change at the point the form is displayed, but there is nothing that initiates this switch!!!

This is really baking my noodle.
Any ideas?
  • 0

Advertisements







Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP