Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Word Macro mysteriously changes active document

  • Please log in to reply



    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


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