Vba

Resolved · High Priority · Version 2010

Mon 12 Dec 2011, 15:41 Delegate Archana said...

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

Tue 13 Dec 2011, 19:00 Trainer Anthony said...

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

Tue 20 Dec 2011: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.