Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding "work" taking place on a worksheet.
Hi there,
I have a macro that copies info from other worksheets and pastes it into the current worksheet. Now, this process "looks" messy. I was wondering if there is a way to have the worksheet it's copying to still visible, but not show the "copying" -- that is, only show something that indicates that work is going on (i.e. like when the cursor shows an hour glass), but doesn't actually show the copying and pasting taking place. Application.visible=false is pretty good for this (I just set application.visible=true at the end of my code), but then the whole application disappears for that time. Is there any way to still have the workbook/worksheets present but just not show the work being done until the work is complete? Thanks, MIka |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding "work" taking place on a worksheet.
Application.Screenupdating = Fals
and true at the end of the procedur ----- mika. wrote: ---- Hi there I have a macro that copies info from other worksheets and pastes it into the current worksheet. Now, this process "looks" messy. I was wondering if there is a way to have the worksheet it's copying to still visible, but not show the "copying" -- that is, only show something that indicates that work is going on (i.e. like when the cursor shows an hour glass), but doesn't actually show the copying and pasting taking place Application.visible=fals is pretty good for this (I just set application.visible=true at the end of my code), but then the whole application disappears for that time. Is there any way to still have the workbook/worksheets present but just not show the work being done until the work is complete Thanks MIk |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding "work" taking place on a worksheet.
Mika;
At the beginning of your sub put this: Application.ScreenUpdating=False Thanks, Greg -----Original Message----- Hi there, I have a macro that copies info from other worksheets and pastes it into the current worksheet. Now, this process "looks" messy. I was wondering if there is a way to have the worksheet it's copying to still visible, but not show the "copying" -- that is, only show something that indicates that work is going on (i.e. like when the cursor shows an hour glass), but doesn't actually show the copying and pasting taking place. Application.visible=false is pretty good for this (I just set application.visible=true at the end of my code), but then the whole application disappears for that time. Is there any way to still have the workbook/worksheets present but just not show the work being done until the work is complete? Thanks, MIka . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
My "IF FUNCTIONS" on excel worksheet do not work | Excel Worksheet Functions | |||
How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel | |||
"Show all" button not work in protected worksheet | Excel Worksheet Functions | |||
pictures to work with "data" "sort" option | Excel Discussion (Misc queries) |