excel vba - Can you show sheet1 when running macros on other sheets?

Question

Is there a way to run different macros on several worksheets but, always show sheet1 when the macros are running?

My sheet1 is a cover sheet (a kind of title page) with a command button. Pressing the command button runs macros on a further 5 sheets. Each sub starts by moving to the correct sheet ...

e.g.

Sheets("CDS Data").Select

... but this sheet is shown whilst the macro is running, can I stop this being shown and just show the sheet1 until all macros are finished?

Thanks

You almost never need to select a sheet to work with it in code, and it is less efficient to do so. Really you ought to rewrite your code so that it explicitly refers to the correct sheet rather than manipulating the active sheet. — Rory

SMORF SMORF · Accepted Answer · 2014-11-20T08:53:04

Actually ... I have found a way. By starting my macros with;

Application.ScreenUpdating = False

This seems to work.

excel vba - Can you show sheet1 when running macros on other sheets?

1 Answers