Application.screenupdating

[teachMeExcel]

I am working on BPC and have issue with the Flickering screen. This is basically the code that i have, The Application.screenupdating is being over ridden from a a BPC COde that I don't have any control over which is the "MNU_ETOOLS_EXPANDANDREFRESH", Is there another command that I can use to control the Screen Updation?.

Thank you very much in advanec for any help on this.

 Application.ScreenUpdating = False      

 Application.Run "MNU_ETOOLS_EXPANDANDREFRESH"

 Application.ScreenUpdating = True

[Paul]

The only thing I can think of would be to hide the entire Excel app while the code is running, then unhide it at the end. I would be careful with this, though, since if an error occurs in the external program it will not make Excel visible again. You could fix it, of course, but other users may have no idea what happened.

Application.Visible = False

Application.Run "MNU_ETOOLS_EXPANDANDREFRESH"

Application.Visible = True

[teachMeExcel]

Thank you very much Paul for that sugesstion. I have given that a try already before but I can't use it since the the maodule in question brings out a pop up box that the user needs to answer thereby hiding the excel apps will not work. But I truly appreciate the suggestion.