tag:blogger.com,1999:blog-55225175730318021422011-07-08T09:59:50.538+01:00Useful IT tip bits of info from the 22 Square Support Team22 Square Teamhttp://www.blogger.com/profile/00811084670697441942noreply@blogger.comBlogger21100tag:blogger.com,1999:blog-5522517573031802142.post-76640677930565806202009-11-04T14:33:00.001Z2009-11-04T15:32:07.839ZHave 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. <br /><br />Folow these steps in Excel;<br /><br />1. Open Macro in Visual Basic Editor (Tools > Macros > Visual Basic Editor)<br />2. Double click on This Workbook on the Project Explorer<br />3. Find the start of your Macro and type Application.ScreenUpdating = False<br /><br />This will stop the screen flickering when the Macro runs, this also has the added bonus of your macros running faster.<br /><br /><a href="http://www.22square.co.uk">22 Square - IT Support Team</a><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5522517573031802142-7664067793056580620?l=it-tip-bits.blogspot.com' alt='' /></div>22 Square Teamhttp://www.blogger.com/profile/00811084670697441942noreply@blogger.com0tag:blogger.com,1999:blog-5522517573031802142.post-48463903002339841902009-10-27T03:26:00.000Z2009-10-27T20:52:51.491Z<div><span class="Apple-style-span" style="font-family: arial; ">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.</span></div><div><span class="Apple-style-span" style="font-family:arial;"><br /></span></div><div><span class="Apple-style-span" style="font-family:arial;">A much wiser man than I once said "if something is worth knowing it is worth sharing"</span></div><div><span class="Apple-style-span" style="font-family:arial;"><br /></span></div><div><span class="Apple-style-span" style="font-family:arial;">Hopefully you will find the blog at the very least a minor distraction for a few moments.</span></div><div><span class="Apple-style-span" style="font-family:arial;"><br /></span></div><div><span class="Apple-style-span" style="font-family:arial;">Enjoy,</span></div><div><span class="Apple-style-span" style="font-family:arial;"><br /></span></div><div><span class="Apple-style-span" style="font-family:arial;">22 Square Support Team </span></div><div><a href="http://www.22square.co.uk"><span class="Apple-style-span" style="font-family:arial;">www.22square.co.uk</span></a></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5522517573031802142-4846390300233984190?l=it-tip-bits.blogspot.com' alt='' /></div>22 Square Teamhttp://www.blogger.com/profile/00811084670697441942noreply@blogger.com0