98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Vba
Vba
Resolved · High Priority · Version 2010
Mon 12 Dec 2011, 15:41Delegate 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:00Trainer 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 information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Change The Default Font in Access 2003You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set. |
