Display a specific sheet always

[EEEHHH]

Display a specific sheet always

Sheet 1 gets data from web using Module 1 (Macro 1)

Sheet 2 gets data from web using Module 2 (Macro 2)

Sheet 3 takes data both from Sheet 1 and 2 for calculations. It has a button Module 3 (Macro 3) which initially starts and runs Macro 1 and 2 periodically say at every 5min.

I want to display / remain on Sheet 3 always, but every time the data refreshes on sheet 1 and 2, I get diverted to sheet 2.

Any solution to always display sheet 3 ?

Thanks

[maniacb]

Add the following code to the end of your macro

Please Login or Register  to view this content.

[EEEHHH]

Gets work done in the sense that it displays Sheet 1 while running Macro 1 then it displays Sheet 2 while Macro 2 runs, thereafter Sheet 3 is displayed.

Any other solution that runs Macro 1 and 2 without displaying / switching to Sheet 1 and 2, i.e. Sheet 3 should display even when the Macros 1 and 2 runs.

I had added the code to the end of Macro 3.

Thanks