| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with Hidden worksheets
I have a workbook with six detail worksheets and a couple of "menu"
worksheets. I am looking for a way to run several macros against the detail sheets without having the user watch them flash by and change during the macro's execution. Is there a command that I can place in the macro to keep the worksheets hidden but still use commands like "ActiveCell"? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Working with Hidden worksheets
Application.ScreenUpdating = False
at the start, and reset to True at the end. -- HTH RP (remove nothere from the email address if mailing direct) "Hibbs" wrote in message ... I have a workbook with six detail worksheets and a couple of "menu" worksheets. I am looking for a way to run several macros against the detail sheets without having the user watch them flash by and change during the macro's execution. Is there a command that I can place in the macro to keep the worksheets hidden but still use commands like "ActiveCell"? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hyperlink not working in excel 2007, if worksheet is hide or hidden | Excel Worksheet Functions | |||
| how do I display footer while working?It is hidden until I print. | Excel Discussion (Misc queries) | |||
| Code not working within hidden column range | Excel Discussion (Misc queries) | |||
| How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
| Hidden worksheets | Excel Programming | |||
Linear Mode
