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.

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.

Hi

Application.Screenupdating=False

Remeber to set it = True again later.

Regards,
Per

"omsoft" skrev i meddelelsen
...
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.

It seems that each time I call a function to do something,
application.screenupdating is reset. So I have to go into every function and
set it to false at the start and true at the end. I put it in many places and
there are a few still left where it does not work.

But when I launch it from the Access app, I was hoping to run it like a
black box. So the user does not know what is happening.

Thanks.

"Per Jessen" wrote:

Hi

Application.Screenupdating=False

Remeber to set it = True again later.

Regards,
Per

"omsoft" skrev i meddelelsen
...
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.

You can hide Excel with this statement:
Application.Visible = False

You can still show your menus and dialogs, even though the rest of Excel is
hidden.

To make Excel visible again:
Application.Visible = True

Hope this helps,

Hutch

"omsoft" wrote:

It seems that each time I call a function to do something,
application.screenupdating is reset. So I have to go into every function and
set it to false at the start and true at the end. I put it in many places and
there are a few still left where it does not work.

But when I launch it from the Access app, I was hoping to run it like a
black box. So the user does not know what is happening.

Thanks.

"Per Jessen" wrote:

Hi

Application.Screenupdating=False

Remeber to set it = True again later.

Regards,
Per

"omsoft" skrev i meddelelsen
...
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.