Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Keeping focus on one worksheet whilst a macro runs

Status
Not open for further replies.
t16turbo

t16turbo

Programmer
Mar 22, 2005
315
GB
My macro opens up several workbooks and then processes the data contained within them.
whilst it runs the screen shows exactly what the macro is doing.

is it possible to keep the macro focused on the worksheet with my 'start' button on it?

 
Sort by date Sort by votes
Why not switch off screen updating instead.

Application.ScreenUpdating=False

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
If obsolete - deactivate all but one macro
Replies
6
Views
606
mintjulep
M
remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
1K
strongm
strongm
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
1K
dhookom
dhookom
remeng
  • Locked
  • Question
CTRL + BREAK from second macro button
Replies
5
Views
1K
strongm
strongm
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
1K
huiettcm
huiettcm

Part and Inventory Search

Sponsor

Back
Top