Enter your search terms Submit search form   web www.msofficegurus.com www.excelguru.ca robermartim.spaces.live.com

ÄThis is a list of all articles published on our site

Below is a list of all articles published on our website. If you think the list is too long and you do not have the time to page through them, please use the search on our site to look for more specific articles or click on your favorite columnist to his/her articles. Also, please note that no columnist is paid to write their columns. So, please, do not expect to see an article every single week. The authors will write accoding to their available time and as and when they wish.

Total number of articles:  22                                                Total pages served: 12.87K

	Sunday, July 06, 2008 User-Defined Function (UDF) naming problem  by Robert Martim Here a little unknown problem that will trigger if you happen to use a function name that already exists in Excel. This problem comes from that fact that the fuction name is the same as a Excel 4.0 macro function name...
	(0 of 0 votes)	Views: 88
	Sunday, July 06, 2008 How to list file names in Excel without VBA  by Robert Martim A lot of people need to list, in a worksheet, files located in a Windows folder! Now, the trouble starts when people decide to use VBA for that. Although this is okay, not everyone is fluent in VBA to write such code. However, there is a simpler trick to that. By using Excel 4.0 macros you can accomplish that very easily. In this video, I show you how to get that done.
	(0 of 0 votes)	Views: 101
	Tuesday, May 27, 2008 Office 2007: Pulsating (flashing) Office Button  by Robert Martim Ever wondered why the Office Button flashes? Or how to make it flash again? Here's a cool trick to make that happen by tweaking the Registry.
	(1 of 1 votes)	Views: 251
	Saturday, May 24, 2008 Customizing the Ribbon: startFromScratch and Tab visibility  by Robert Martim If you start from scratch, then using the getVisible attribute to show/hide a tab will not work, since you'd have to rebuild the functionalities for the elements. However, an option would be to simply start all tabs hidden and then show/hide as you go along, this would avoid the frustrating of having to rebuild each tab using XML to work with them.
	(0 of 0 votes)	Views: 132
	Friday, May 09, 2008 Excel 2007 Charting: A home theater out of a chart (interactive video)  by Robert Martim A few days ago, I presented via YouTube (see article on this link http://www.msofficegurus.com/gArticle.asp?IDArticle=43) a video teaching you how to create a chart that looked like one of those Home Theater stands. The problem with YouTube videos is the quality. Also, it does not give interaction, which can compromise the learning experience...
	(2 of 2 votes)	Views: 103
	Monday, April 28, 2008 Excel 2007 Charting: Making a home theater out of a chart  by Robert Martim Charting in Excel is quite simple and sometimes, with a bit of imagination, we can create some really appealing charts. In this example, I show you how to create a chart that looks like one of those home theater stands.
	(0 of 0 votes)	Views: 110
	Wednesday, April 23, 2008 Highlight active row in Excel 2007  by Robert Martim Ever wanted to highlight the active row as you select through a worksheet? Here's how simple it is...
	(1 of 1 votes)	Views: 159
	Sunday, December 09, 2007 Creating Outlook 2007 Rules from Excel 2007  by Robert Martim If you use e-mails, you have certainly received loads of junk in the past and will continue to get more in the future. There are many ways you can deal with junk mail such as using a specialized tools (antispam tools). Alternatively you can use the Rules and Alerts function of Outlook to filter unwelcome e-mail.
	(1 of 1 votes)	Views: 169
	Monday, July 10, 2006 Word – User Interface  by Renato Haddad This article introduces the reader to the new User Interface (UI) for Microsoft Word 2007.
	(2 of 2 votes)	Views: 499
	Thursday, February 16, 2006 Building custom toolbars in MS Access - Part 3  by Robert Martim This is the third part of creating custom toolbars in Access. In this part, I show how to execute a command and how to use the OnAction property and the Execute method...
	(3 of 6 votes)	Views: 677

All views presented in these articles are the sole responsibility of the author. Articles are supplied "as they are".