Archana has attended:
Excel VBA Intro Intermediate course
Excel Pivot Tables course
Vba
I have just added the
Application.screenupdating= false
and then= true at the end of the sub routine
while running the macro but I find that the system seems to freeze and the dialogue box which asks what macro to run is frozen on the screen so the first thing that comes into your mind is that excel is frozen, but actually the macro is running!how can I get rid of the Dialogue box before the macro starts
RE: Vba
Hi Archana, thanks for your query. First of all, this is Excel we're talking about, yes? You posted the query in the Access VBA section and the macro dialogue box can cause problems when running code in Access.
However, if you're in Excel you should get that macro dialogue box coming up if your cursor is flashing within a subroutine and you run the code from there. If the code is attached to a worksheet control, the subroutine name may have changed and become dissociated from the control. Finally, can you paste the entire subroutine here so we can have a better look at what is going on?
Hope this helps,
Anthony
