Making sure one workbook is on top

[AliJay]

Hi Guys,

I need some help on what is probably a minor point any help would be greatly appreciated.

I run a process that collects data and stores it every 20 minutes. For historical reasons the way the process is set up I need to have 2 workbooks open at the same time.

WorkBook1 stores the data every 20 minutes and has the macros assigned to it while Workbook2 receives the data. If (accidentally) WorkBook2 is on top when the 20 minute macro runs to store the data in WorkBook1 then the whole data process breaks down and I have to manually reset it. Leading to mucho frustration.

Is there a VBA command that I can place at the start of the 20 minute macro that will force WorkBook1 on top if WorkBook2 happens to be on top before the 20 minute macro operates?

Thanks in advance,

[michson]

Try this:

Please Login or Register  to view this content.

[AliJay]

Thanks so much for that Michson. So in my example I would substitute "FirstWB" as "WorkSheet1" and it should work?

[michson]

AliJay, you were talking about workbook. So there should be your Workbook name.

[AliJay]

Thanks again mate...