Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, hiding and showing sheets | Excel Discussion (Misc queries) | |||
hiding zero values on all sheets & by default on new sheets | Excel Worksheet Functions | |||
Locking Sheets / Hiding Sheets | Excel Worksheet Functions | |||
Hiding sheets in Excel | Excel Programming | |||
Hiding sheets in Excel | Excel Programming |