| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
I'm sure this has been answered before, but nevertheless I need a little help.
I have created a pretty big spreadsheet and when I run one of the macros it goes to many sheets and does a lot of cutting and pasting . I would like to create a macro that stops the screen from showing all the other movements and just display a single screen, maybe even putting a pop up message that says "Report Reformmating. Please Wait" anyone able to help? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macros
Ken
Just add this to the top of your macro Application.ScreenUpdating=False and perhaps Application.StatusBar="Report Reformmating. Please Wait" "KenL" wrote: I'm sure this has been answered before, but nevertheless I need a little help. I have created a pretty big spreadsheet and when I run one of the macros it goes to many sheets and does a lot of cutting and pasting . I would like to create a macro that stops the screen from showing all the other movements and just display a single screen, maybe even putting a pop up message that says "Report Reformmating. Please Wait" anyone able to help? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macros
activate or unhide a "please wait" sheet
application.screenupdating=false 'do stuff application.screenupdating=true re-hide "Please wait" sheet Tim. "KenL" wrote in message ... I'm sure this has been answered before, but nevertheless I need a little help. I have created a pretty big spreadsheet and when I run one of the macros it goes to many sheets and does a lot of cutting and pasting . I would like to create a macro that stops the screen from showing all the other movements and just display a single screen, maybe even putting a pop up message that says "Report Reformmating. Please Wait" anyone able to help? Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macros
Guys Thanks for your help! "Tim Williams" wrote: activate or unhide a "please wait" sheet application.screenupdating=false 'do stuff application.screenupdating=true re-hide "Please wait" sheet Tim. "KenL" wrote in message ... I'm sure this has been answered before, but nevertheless I need a little help. I have created a pretty big spreadsheet and when I run one of the macros it goes to many sheets and does a lot of cutting and pasting . I would like to create a macro that stops the screen from showing all the other movements and just display a single screen, maybe even putting a pop up message that says "Report Reformmating. Please Wait" anyone able to help? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
| Open workbook-macros enabled, opening another with macros | Excel Programming | |||
| Macro Size Limit / open macros with macros? | Excel Programming | |||
| Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
| Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
Linear Mode
