Browse by Tags

Hi All, Many users (including customers of mine) have experienced trouble with two recent security updates by Microsoft, see: http://support.microsoft.com/kb/973475 and http://support.microsoft.com/kb/973593 There seem to be two hotfixes to this problem: KB973475 Excel 2003 hotfix package : http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=978908&kbln=en-us KB973593 Excel 2007 hotfix package : http://support.microsoft.com/default.aspx?scid=kb;EN-US;978522 If you experience problems with...

As a fulltime developer I oftentimes open files containing VBA and want to be able to run code. At the same time I sometimes want to prevent Workbook_Open event code or an Auto_Open macro from running. With Excel 97 to 2003, this was simple: hold the shift key when you click “Enable macros”. With Excel 2007 and [...] Read More...

My previous post went a bit unnoticed, but I bet this one might interest some of the Office developers… In that post, I showed how to access and modify existing parts of an Office OpenXML package. This opens up the path for us to add ribbon customisation code to an Office file. For this to happen, [...] Read More...

Nick Hodge has been getting a lot of press lately. First, he recently appeared on J-Walk’s blog. More recently, he was featured on the MVP blog. I’ve been reading that MVP blog since it started and finally I know somebody. I guess I can quit reading it now. Good job, [...] Read More...

Hi all, I’ve just published a new article on my website. Here is the introduction: “This article explains how you can use styles to ease maintenance of your spreadsheet models. Microsoft has made it very easy to dress up your worksheets with all sorts of fill patterns, borders and other frills. Because formatting of cells is often done [...] Read More...