Macro opens workbook in background

[Sven62]

The macro shown is from a command button on a userform. Ever since we were "upgraded" to Office 2016 this macro opens the workbook behind the current window instead of on top... you know... where you can SEE IT!

Is there an easy way to force these open docs to open on top?

Sub NTMOORG()
Workbooks.Open FileName:="S:\OPS\NOM-NTMO Org Chart 2017.xlsx", ReadOnly:=True
End Sub

 

[shg]

Maybe ...

workbooks(workbooks.count).activate

I would prefer the behavior you have now.

 

[Sven62]

"A" for effort.... but does not work. Thanks for trying!

 

[shg]

Curious -- works for me.

 

[Sven62]

Where are you placing that line? Maybe I am not using it correctly.

 

[shg]

After you open the other workbook.

 

[Sven62]

Do you mean like this?

Sub NTMOORG()
Workbooks.Open FileName:="S:\OPS\NOM-NTMO Org Chart 2017.xlsx", ReadOnly:=True
Workbooks(Workbooks.count).activate
End Sub

 

[Sven62]

Hmm... well they are clicking on a command button to open a specific doc and now when they do that they that they don't see anything unless they notice on the taskbar that there is another Excel workbook now open in the background. But I am not confident people will notice that or even look for it. They will just wonder why they can't see the doc they want to see.