Posted to microsoft.public.excel.programming

Salman[_2_] Salman[_2_] is offline

external usenet poster

Posts: 4

Keep display steady while macro runs

Hi. I have a simple macro that cuts and pastes values from
different tabs to an output tab. Sample code is:

Sheets("addressing").Select
Range("svcstack").Select
Selection.Copy
Sheets("Output driver page").Select
Range("cell1").Select
Selection.PasteSpecial Paste:=xlValues

Problem is that while the code runs, each tab selected is
displayed. I would like to keep the output tab, call
it "output", displayed as the macro runs. Please help.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs	Rruffpaw	Setting up and Configuration of Excel	1	September 17th 11 01:25 PM
One macro runs then it auto runs another macro	PG	Excel Discussion (Misc queries)	2	September 1st 06 09:30 PM
Which Macro Runs...?	Bill Martin	Excel Discussion (Misc queries)	7	September 29th 05 12:42 PM
Display a message whilst a macro runs	steve	Excel Programming	0	October 29th 03 07:37 PM
Display a message whilst a macro runs	Tom Ogilvy	Excel Programming	0	October 29th 03 12:43 PM

All times are GMT +1. The time now is 04:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us