Help needed on making code more efficient

[FallingDown]

Hi all

I have an ExcelFile containing 200 Sheets

In VBA the following code is entered

Please Login or Register  to view this content.

Now when I enter a value in $G$3 the tabs names containing the entry display immediately.
However, when I delte the value in the cell it takes about 10 seconds for all other sheets to unhide.

How can I optimize the above code, so that all other sheets unhide immediately?
I have tried to set calculation to manual, resp. automatic, but this actually takes lnonger.

Many thanks

FD

[DonkeyOte]

Have you tried toggling screen update ?

Please Login or Register  to view this content.

You could also add a pre-emptive test of Target ("") to avoid performing the InStr

[FallingDown]

Hi DonkeyOte

Thanks a lot for this.

I have very slightly altered your code to:

Please Login or Register  to view this content.

I have done this, because $C$1 is updated on all sheets via a macro assigned to a Form Control Button.
My change makes this macro run faster.

Have a great new year!

FD