Have you ever writen or recorded a Macro for Excel but when you run the macro your screen flickers. An easy fix is to turn off the Screen Updating in your script.
Folow these steps in Excel;
1. Open Macro in Visual Basic Editor (Tools > Macros > Visual Basic Editor)
2. Double click on This Workbook on the Project Explorer
3. Find the start of your Macro and type Application.ScreenUpdating = False
This will stop the screen flickering when the Macro runs, this also has the added bonus of your macros running faster.
22 Square - IT Support Team
Wednesday 4 November 2009
Tuesday 27 October 2009
Welcome to the New 22 Square Support Team Blog
We have started blog to post useful tip bits of info that we come across. The posts will be a mixture of tutorials, tweaks and general guidance for customers and anyone that may find it useful.
A much wiser man than I once said "if something is worth knowing it is worth sharing"
Hopefully you will find the blog at the very least a minor distraction for a few moments.
Enjoy,
22 Square Support Team
Subscribe to:
Posts (Atom)