Does ActiveWorkbook work when Screenupdating is turned off?!
 

Just out of interest:
Is Activeworkbook dangerous to use when screenupdating is turned off?
I've got some code where certain commands don't seem to be executing:
but if I turn screenupdating on then they fire ok - just wondering if
this is to do with my use of ActiveWorkbook ?

Any help greatly appreciated,
Jason.

Does ActiveWorkbook work when Screenupdating is turned off?!
 

The two are independent.

In article . com,
"WhytheQ" wrote:

Just out of interest:
Is Activeworkbook dangerous to use when screenupdating is turned off?
I've got some code where certain commands don't seem to be executing:
but if I turn screenupdating on then they fire ok - just wondering if
this is to do with my use of ActiveWorkbook ?

Any help greatly appreciated,
Jason.