LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default VBA Macros that don't steal focus?


I have written a set of sub's and functions that handle formattin
several sheets in my workbook. The problem is that in the process o
activating the sheets and making my formatting changes the windo
appears like it's going crazy. Is there a way I can turn off the focu
change before my macro runs amd then turn it back on after it's done?

Thanks,

Morp

--
morpheleo
-----------------------------------------------------------------------
morpheleon's Profile: http://www.msusenet.com/member.php?userid=282
View this thread: http://www.msusenet.com/t-187057358

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
set focus tkaplan Excel Discussion (Misc queries) 3 September 27th 05 07:41 PM
VBA Macros that don't steal focus? [email protected] Excel Programming 1 June 29th 05 03:45 PM
focus Art[_6_] Excel Programming 1 June 7th 04 05:53 PM
Set Focus gregork Excel Programming 2 March 7th 04 05:29 AM
How do I set focus Newbie Excel Programming 2 February 11th 04 07:03 PM


All times are GMT +1. The time now is 06:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"