I'm not sure what your macro is doing, but if it is updating data, or changing 
sheets,
then the display is updating.

Try using:

Application.screenupdating = false

at the beginning of your macro and:

Application.screenupdating = true

at the end.

Paul


>
>From: Chandra Shekar <chandrashekarb....@gmail.com>
>To: excel-macros@googlegroups.com
>Sent: Tue, November 23, 2010 5:47:19 AM
>Subject: Re: $$Excel-Macros$$ On Time
>
>
>Hi,
>
>Thank you for the reply, if I run this macro excel will start flickering. How 
>to 
>stop this please run the program and see. Thanks
>
>Regards,
>
>Chandra Shekar
>
>
>On Tue, Nov 23, 2010 at 1:50 PM, SUMIT VYAS <svyas0...@gmail.com> wrote:
>
>find herewith 
>>
>>
>>thanks 
>>
>>sumit 
>>
>>
>>
>>
>>On Mon, Nov 22, 2010 at 4:29 PM, Chandra Shekar 
>><chandrashekarb....@gmail.com> 
>>wrote:
>>
>>Hi,
>>>
>>>Any help please
>>>
>>>Thanks
>>>
>>>
>>>On Fri, Nov 19, 2010 at 6:07 PM, Chandra Shekar 
>>><chandrashekarb....@gmail.com> 
>>>wrote:
>>>
>>>Hi,
>>>>
>>>>When I run the program excel starts flicekring how to avoid this. 
>>>>
>>>>Thanks
>>>>
>>>>Chandra Shekar-- 
>>>>----------------------------------------------------------------------------------
>>>>
>>>>Some important links for excel users:
>>>>1. Follow us on TWITTER for tips tricks and links : 
>>>>http://twitter.com/exceldailytip
>>>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>>3. Excel tutorials at http://www.excel-macros.blogspot.com/
>>>>4. Learn VBA Macros at http://www.quickvba.blogspot.com/
>>>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/
>>>>
>>>>To post to this group, send email to excel-macros@googlegroups.com
>>>> 
>>>><><><><><><><><><><><><><><><><><><><><><><>
>>>>Like our page on facebook , Just follow below link
>>>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>>
>>>-- 
>>>----------------------------------------------------------------------------------
>>>
>>>Some important links for excel users:
>>>1. Follow us on TWITTER for tips tricks and links : 
>>>http://twitter.com/exceldailytip
>>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>>To post to this group, send email to excel-macros@googlegroups.com
>>> 
>>><><><><><><><><><><><><><><><><><><><><><><>
>>>Like our page on facebook , Just follow below link
>>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>-- 
>>----------------------------------------------------------------------------------
>>
>>Some important links for excel users:
>>1. Follow us on TWITTER for tips tricks and links : 
>>http://twitter.com/exceldailytip
>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>To post to this group, send email to excel-macros@googlegroups.com
>> 
>><><><><><><><><><><><><><><><><><><><><><><>
>>Like our page on facebook , Just follow below link
>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>-- 
>----------------------------------------------------------------------------------
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
> 
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Reply via email to