PC Review


Reply
Thread Tools Rate Thread

Block display during Macro

 
 
Juan García
Guest
Posts: n/a
 
      27th Oct 2008
Hello,
I execute a macro that go across the sheet and insert and copy a lot of rows
and formats I would like the user doesn´t see the process, only the results.
Is possible 'lock' visual effects during the macro execution.
Thanks.-


 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      27th Oct 2008
Application.ScreenUpdating = False

'your code

Application.ScreenUpdating = True

--
__________________________________
HTH

Bob

"Juan García" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
> I execute a macro that go across the sheet and insert and copy a lot of
> rows and formats I would like the user doesn´t see the process, only the
> results. Is possible 'lock' visual effects during the macro execution.
> Thanks.-
>



 
Reply With Quote
 
Juan García
Guest
Posts: n/a
 
      27th Oct 2008
Thanks...
"Bob Phillips" <(E-Mail Removed)> escribió en el mensaje
news:(E-Mail Removed)...
> Application.ScreenUpdating = False
>
> 'your code
>
> Application.ScreenUpdating = True
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Juan García" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hello,
>> I execute a macro that go across the sheet and insert and copy a lot of
>> rows and formats I would like the user doesn´t see the process, only the
>> results. Is possible 'lock' visual effects during the macro execution.
>> Thanks.-
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: Firefox and display:block; bruce barker Microsoft ASP .NET 0 5th Feb 2008 10:56 PM
Re: Firefox and display:block; PA Bear [MS MVP] Windows XP Internet Explorer 0 5th Feb 2008 10:29 PM
Re: Firefox and display:block; PA Bear [MS MVP] Microsoft ASP .NET 0 5th Feb 2008 10:29 PM
Re: Firefox and display:block; C A Upsdell Microsoft ASP .NET 2 5th Feb 2008 09:23 PM
Re: Firefox and display:block; C A Upsdell Windows XP Internet Explorer 2 5th Feb 2008 09:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:10 AM.