Share via

Preview pane interfering with Macro template

Anonymous
2017-10-01T22:55:16+00:00

We have a few macros in our office we use for creating template documents we are running Windows 10 and office 2010 (we're behind we know).

If we open the templates through explorer with the preview pane active the popup dialog opens behind the active window and the word document doesn't even come up at all. 

I have tested that it works when copied to the desktop and when the preview pane is disabled but it's not really a viable solution as much as it is just a work around.

If you have any fixes for us that would be great

Thanks,

Moved from: Office /Word / Windows 10 / Office 2010

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2017-10-03T13:35:20+00:00

If your templates are macro driven, you might be able to insert the following VBA code into their startup routine and all open windows will be minimized.

    Dim objShell

    Set objShell = CreateObject("shell.application")

    objShell.MinimizeAll

    Set objShell = Nothing

Hope this helps

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

0 additional answers

Sort by: Most helpful