excel vba - open workbooks hidden?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mondrogan - 09 Mar 2007 02:05 GMT

I'm new to VBA and I'm running my first lengthy program. I notice a lot of
background activity as various workbooks and sheets are activated by my
code. Very annoying and slow. Is there a way to minimize this background
activity? Can we open files hidden?

Reply to this Message

David McRitchie - 09 Mar 2007 02:32 GMT

Hi Mondrogan,
Suggest you take a look at
http://www.mvps.org/dmcritchie/excel/slowresp.htm
http://www.mvps.org/dmcritchie/excel/proper.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> I'm new to VBA and I'm running my first lengthy program. I notice a lot of
> background activity as various workbooks and sheets are activated by my
> code. Very annoying and slow. Is there a way to minimize this background
> activity? Can we open files hidden?

Reply to this Message

Mondrogan - 10 Mar 2007 01:39 GMT

Many thanks. This is valuable information.

> Hi Mondrogan,
> Suggest you take a look at
[quoted text clipped - 11 lines]
>> code. Very annoying and slow. Is there a way to minimize this background
>> activity? Can we open files hidden?

Reply to this Message