Hi,

I'm developing a class which opens the MS Excel
and extend the context menu with a new item. When the item is clicked all it
does is to popup a message box.
While the message box is displayed, it seems that Excel is locked up and not
redrawing its surface until message box control returns to it, that is,
until the message box is acknowledged.

I mention that my class is not a macro. It just accesses the Excel from
within an .NET Windows Application.

Any idea why MS Excel framwork does not get repaint while the message box is
shown?

Thanks,
Mircea

"Mircea Pleteriu" wrote in message
...
Hi,

I'm developing a class which opens the MS Excel
and extend the context menu with a new item. When the item is clicked all
it
does is to popup a message box.
While the message box is displayed, it seems that Excel is locked up and
not
redrawing its surface until message box control returns to it, that is,
until the message box is acknowledged.

I mention that my class is not a macro. It just accesses the Excel from
within an .NET Windows Application.

Any idea why MS Excel framwork does not get repaint while the message box
is
shown?

Thanks,
Mircea



What happens if you drag the messagebox around? Will it be all white?

/Fredrik

Not at all. The Excel does not repaint and an image with the message box at
the previous position remains on the screen.

"Fredrik Wahlgren" wrote in message
...

"Mircea Pleteriu" wrote in message
...
Hi,

I'm developing a class which opens the MS Excel
and extend the context menu with a new item. When the item is clicked
all
it
does is to popup a message box.
While the message box is displayed, it seems that Excel is locked up and
not
redrawing its surface until message box control returns to it, that is,
until the message box is acknowledged.

I mention that my class is not a macro. It just accesses the Excel from
within an .NET Windows Application.

Any idea why MS Excel framwork does not get repaint while the message
box
is
shown?

Thanks,
Mircea



What happens if you drag the messagebox around? Will it be all white?

/Fredrik

"Mircea Pleteriu" wrote in message
...
Not at all. The Excel does not repaint and an image with the message box
at
the previous position remains on the screen.


So you end up with 2 or more messageboxes? Can you attach a screen copy. I
know I had a problem like this a long time ago, I hope I can remeber the
solution.

/Fredrik

Hi Mircea,

Try setting the ScreenUpdating property of the Excel Application object to
True before displaying any forms or messageboxes. I'm not sure why it would
be False, as it defaults to True. But explicitly setting it to True should
fix what you're seeing.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Mircea Pleteriu wrote:
Hi,

I'm developing a class which opens the MS Excel
and extend the context menu with a new item. When the item is clicked
all it does is to popup a message box.
While the message box is displayed, it seems that Excel is locked up
and not redrawing its surface until message box control returns to
it, that is, until the message box is acknowledged.

I mention that my class is not a macro. It just accesses the Excel
from within an .NET Windows Application.

Any idea why MS Excel framwork does not get repaint while the message
box is shown?

Thanks,
Mircea

"Jake Marx" wrote in message
...
Hi Mircea,

Try setting the ScreenUpdating property of the Excel Application object to
True before displaying any forms or messageboxes. I'm not sure why it
would
be False, as it defaults to True. But explicitly setting it to True
should
fix what you're seeing.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com


I.m not sure it will help but it's worth trying. I did a test where I set
this property to false. I then dragged other windows over Excel, both from
Excel and from other programs. Excel redraw as it should. I don't think this
command prevents Excel's main window from being redrawn although it prevents
updated values in cells to appear.

/Fredrik

Still not working. I coded in C#. Could it be a problem?

"Fredrik Wahlgren" wrote in message
...

"Jake Marx" wrote in message
...
Hi Mircea,

Try setting the ScreenUpdating property of the Excel Application object
to
True before displaying any forms or messageboxes. I'm not sure why it
would
be False, as it defaults to True. But explicitly setting it to True
should
fix what you're seeing.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com


I.m not sure it will help but it's worth trying. I did a test where I set
this property to false. I then dragged other windows over Excel, both from
Excel and from other programs. Excel redraw as it should. I don't think
this
command prevents Excel's main window from being redrawn although it
prevents
updated values in cells to appear.

/Fredrik

Do I have to set the parent of the message box to point to the Excel's main
window?

"Fredrik Wahlgren" wrote in message
...

"Jake Marx" wrote in message
...
Hi Mircea,

Try setting the ScreenUpdating property of the Excel Application object
to
True before displaying any forms or messageboxes. I'm not sure why it
would
be False, as it defaults to True. But explicitly setting it to True
should
fix what you're seeing.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com


I.m not sure it will help but it's worth trying. I did a test where I set
this property to false. I then dragged other windows over Excel, both from
Excel and from other programs. Excel redraw as it should. I don't think
this
command prevents Excel's main window from being redrawn although it
prevents
updated values in cells to appear.

/Fredrik