Hi
I remember a long time ago being able to turn of screen changes when Macro's are running
between different work books in an Excel sheet.Can anybody remind me.
Thanks Paul
Hi
I remember a long time ago being able to turn of screen changes when Macro's are running
between different work books in an Excel sheet.Can anybody remind me.
Thanks Paul
Use this
Application.ScreenUpdating = False
'your code
Application.ScreenUpdating = True
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Paul" <[email protected]> wrote in message news:[email protected]...
> Hi
>
> I remember a long time ago being able to turn of screen changes when Macro's are running between different work books in an Excel
> sheet.Can anybody remind me.
>
> Thanks Paul
>
Ron
Many thanks for your speedy reply problem solved
Paul
"Ron de Bruin" <[email protected]> wrote in message
news:%[email protected]...
> Use this
>
> Application.ScreenUpdating = False
> 'your code
> Application.ScreenUpdating = True
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Paul" <[email protected]> wrote in message
> news:[email protected]...
>> Hi
>>
>> I remember a long time ago being able to turn of screen changes when Macro's are
>> running between different work books in an Excel sheet.Can anybody remind me.
>>
>> Thanks Paul
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks