Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > VBA / Office Integration > Excel > Excel Macro question


Reply
 
Thread Tools Display Modes
  #1  
Old 03-22-2003, 12:24 AM
Jdo300's Avatar
Jdo300 Jdo300 is offline
Junior Contributor
 
Join Date: Jul 2002
Location: Ohio
Posts: 287
Question Excel Macro question


I'm just curious. Is there any kind of property of a spreadsheet that you can set to stop it from updating formatting changes? I have macros that Run lengthy formatting operations, and although I used Range objects to manipulate the cells the program can run slow because it always wants to refresh after every single change... So can I temporarily stop it from doing this while my macro is running?
__________________
Microsoft Works..... Hahahahaaha
Reply With Quote
  #2  
Old 03-22-2003, 08:45 AM
Wamphyri's Avatar
Wamphyri Wamphyri is offline
Variable not defined

Retired Moderator
* Guru *
 
Join Date: Apr 2002
Location: Ottawa, Ontario
Posts: 4,793
Default

Quote:
Originally Posted by Jdo300
I'm just curious. Is there any kind of property of a spreadsheet that you can set to stop it from updating formatting changes? I have macros that Run lengthy formatting operations, and although I used Range objects to manipulate the cells the program can run slow because it always wants to refresh after every single change... So can I temporarily stop it from doing this while my macro is running?
Use Application.ScreenUpdating=False at the beginning of your macro
And Application.ScreenUpdating=True at the end of your macro.
You'll notice an increase in speed. Typically, during testing I don't use the ScreenUpdating property just so I can see exactly what is happening.
__________________
-Carl
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Automation Macro in Excel baxel Word, PowerPoint, Outlook, and Other Office Products 5 02-21-2003 01:19 AM
Run Access macro from Excel macro TrentG Word, PowerPoint, Outlook, and Other Office Products 3 12-09-2002 11:57 AM
Repeating List remmarg Interface and Graphics 2 10-30-2002 06:57 PM
Excel macro security BUD Word, PowerPoint, Outlook, and Other Office Products 15 07-31-2002 01:39 PM
Showing Excel Macro status fizbim Word, PowerPoint, Outlook, and Other Office Products 2 03-11-2002 04:23 AM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->