Wierd that setting Application.Screenupdating doesn't work. However, you
could minimize the Excel application's window with Application.WindowState =
xlMinimized, and then put it back with Application.WindowState = xlMaximized
or Application.WindowState = xlNormal when everything is done.

--
J. Andrew Smith
Senior Systems Analyst
Standard & Poor''''s, NYC



"omsoft" wrote:

I have an Excel application with a bunch of menus and dialogs.

This app can also be invoked from another Acces app, or can be invoked in a
standalone mode.

In the app, I activate various sheets at different points to do stuff. Is
there a way I can stop the screen from refreshing? Or when launched from
Access, can I run it as a black box?

I tried application.screenupdating, but that does not do what I need.

Thanks.