Disable Display When Updating from other Workbooks

[howard]

I have a workbook BR1VOA.NV that has a macro that Updates another workbook VOA1 and then copies the data to the workbook BR1VOA.NV

The macro works fine, except that you can see workbook VOA1 being updated. I have tried using application.screenupdating = False, but it still shows the other worbook being updated

It would be appreciated if you could assist

regards

Howard

 

[DonkeyOte]

Hi Howard, I can't think of any reason as to why the ScreenUpdate call would fire unless in wrong place... can you post up the code you have ?

Do you have any code for ex that fires in the 2nd workbook when it's opened which might be forcing screenupdating to true (ie override previous setting) ?

 

[howard]

Hi Lasw10

Thanks for the reply. I have several sepwerate macro's and then one Macro called Auto_Update which runs the other macro's. I never have the Screenupdating in the Macro Auto_Update. I have now set it, and it works perfectly

Regards

Howard

 

[DonkeyOte]

Excellent - it was pointed out to me that ScreenUpdate will revert to true on completion of the routine in which it resides so as you say if it was previously in an invoked routine (ie called via another, ie from the "master" routine) it would reset to true once that particular sub routine had finished... moving to the "master" routine will ensure it's set to False until that routine has finished (and will thus be applied across any/all other routines invoked from "master").