Msofficegurus - msofficegurus.com - MS Office Gurus
General Information:
Latest News:
Customizing the Office 2010 Ribbon via XML (Autoscale) 23 May 2010 | 12:06 am
We all know how difficult it was to customize (or personalize, if you prefer) Office 2007. That changed a lot in Office 2010 and everything has become much, much simpler. A major change in this custom...
Microsoft Office Web Services Toolkit 17 Feb 2010 | 02:18 pm
Can't install the Microsoft Office Webservices Toolkit for Microsoft Office 2003 because you are using Office 2007? This is a problem I came across a few years ago and the solution is simpler than one...
Access 2007 move items between listboxes, filter listbox and clear listbox Items 14 Feb 2010 | 03:11 am
Have you ever wondered how to move items between listboxes in Microsoft Access using VBA? How about filtering listbox items as you type? Using VBA in Microsoft Access, the objectives of this artic...
Office 2010 Customizing the Ribbon 3 Jan 2010 | 04:35 am
Microsoft Office 2010 (Beta) has come with a nice new feature that allows any earthling to change the looks of his or her user interface, aka, the Ribbon. When Microsoft Office 2007 came into existanc...
Microsoft Word Outline 24 Dec 2009 | 05:38 am
Sometimes, we have a very large document in Microsoft Word and need to move sections of the document around. In order to move such document sections, people often copy and paste. However, this is inne...
Office 2007 CustomUI GroupAddInsCustomToolbars 17 Nov 2009 | 12:33 pm
For many people out there, who have written AddIns for Excel using VB6, they find themselves with a dilemma: how do I add my custom toolbar to another Ribbon tab? Well, I honestly do not have an answ...
Excel Highlight the Active Cell 15 Nov 2009 | 01:49 am
In a video (http://www.youtube.com/watch?v=bGjqDGF7xaM) published on YouTube back in 2008, I explained how to highlight the active row in Excel. In this brief article, I discuss how you can highlight ...
Word 2007 random text 8 Sep 2009 | 08:08 am
The other day I had to teach a Word course and I normally take a text with me so that people can replicate what is being taught. This time, however, I decided to use an old trick from Word whereby you...
Excel 2010: Conditional Format Data Bars Improvements 26 Aug 2009 | 05:33 am
Excel 2010 reinvents the conditional format for data bars. We now have more control over the conditional formatting as a whole and not only databars; however, with data bars we now have the option to ...
Excel 2010 No Cell Icon 18 Aug 2009 | 12:09 am
Excel 2007 introduced Icon Sets to Excel Conditional Formatting. Excel 2010 introduces No Cell Icon to Conditional Formatting. In Excel 2007, after applying your Icon Set Conditional Format, you would...
