I'm pretty sure this is a memory issue, but I have a macro that has message
boxes come up and when you drag them they bleed all over the screen wherever
they're dragged. Would anyone know how I might correct this? My file is
fairly large at around 2 megs.

Thanks.

If you change screenupdating to true, I bet the problem goes away:

application.screenupdating = true
msgbox "your message here"
application.screenupdating = false



Modell wrote:

I'm pretty sure this is a memory issue, but I have a macro that has message
boxes come up and when you drag them they bleed all over the screen wherever
they're dragged. Would anyone know how I might correct this? My file is
fairly large at around 2 megs.

Thanks.

--

Dave Peterson

Hi,

If Dave's suggestion of Screenupdating doesn't work check your code to
make sure you have not activated or selected a cell/range on a hidden sheet.

Cheers
Andy

Modell wrote:
I'm pretty sure this is a memory issue, but I have a macro that has message
boxes come up and when you drag them they bleed all over the screen wherever
they're dragged. Would anyone know how I might correct this? My file is
fairly large at around 2 megs.

Thanks.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

That works! Thanks so much.

"Dave Peterson" wrote:

If you change screenupdating to true, I bet the problem goes away:

application.screenupdating = true
msgbox "your message here"
application.screenupdating = false



Modell wrote:

I'm pretty sure this is a memory issue, but I have a macro that has message
boxes come up and when you drag them they bleed all over the screen wherever
they're dragged. Would anyone know how I might correct this? My file is
fairly large at around 2 megs.

Thanks.

--

Dave Peterson