Tuesday, April 26, 2011

Excel VBA: How to Break Links to External Workbooks

Back in 2007 one of the prettiest pieces of VBA code was given free to the people. If you have ever needed a good programmatic way to remove all external workbook links from a single workbook, check this link.

Thursday, April 14, 2011

Top Microsoft Twitter Accounts Every Cubicle Worker Shoud Follow

@MSExcel - Official Twitter account of the product team that brings to you a little piece of software we call Excel.

@msaccess - I am Ryan McMinn a Program Manager on the Access Team; email me at ryan.mcminn@microsoft.com

@Office - Tweets to help you do more with Office at work, home and school. 

@OfficeBI - Covering Microsoft's Business Intelligence products on the Office Platform including SharePoint, Excel, & Excel Services.

@Office_Live - Tweets from the team at Microsoft Office Live

@SharePoint - The SharePoint Product Group

@ch9 -  Channel 9 keeps you up to date with videos from people behind the scenes building products at Microsoft.


Excel VBA: Remove All Conditional Formatting From Sheet

At times you may experience issues with macros when having lots of conditional formatting rules on a sheet. Here's the magic with which you can remove all conditional formatting rules from a sheet:

Sheets("MySheet").Cells.FormatConditions.Delete