Hiding sheets in Excel
 

Use the following:

Application.ScreenUpdating = False
Application.ScreenUpdating = True


-----Original Message-----
Hi all,

I have put together a little macro that hides and unhide
sheets when
pressing various buttons. The problem is that when it
unhides one sheet and
covers another you can see what is happening in the
background even though
it is fast.

Is there a way that when the respective button is pressed
the commands that
are being carried out aren't shown.

If i remember rightly when righting a batch file in dos
you use "Echo off" i
think, is there something similar for excel.

Thank you all for your help
Pantelis


.