View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chase[_3_] Chase[_3_] is offline
external usenet poster
 
Posts: 1
Default 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


.