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...

Hi all, As some of you may be aware, Excel 2007 has been exhibiting an obscure but very annoying bug. On some rare occasions, Range Names may disappear from your workbook after saving it. I have never been able to detect any pattern in this behaviour, it just happens on and off. I’m happy to say Microsoft created [...] Read More...

Hi all Today I upload a new page with examples to Hide or display Custom Tabs, Groups or Controls with VBA code Hide or Display Custom Ribbon Tab/Group/Control with getVisible http://www.rondebruin.nl/hidevisible.htm If you have suggestions to make the examples better please let me know. I am no expert but love to try new stuff like this. Regards Ron de Bruin http://www.rondebruin.nl/tips.htm Read More...

Hi Everyone! Today I finally found time to actually post a brand new article on my website. Wouldn’t it be useful to be able to edit the contents of an Office 2007 OpenXML file from within VBA? Well, now you can, using the sample code and explanation in this article. Enjoy!! Regards, Jan Karel Pieterse www.jkp-ads.com Read More...

Ever wondered what it means to have Excel multi-thread its calculations? On a 64bit I7 computer, crunching 500,000 rows of calculations for the Euler 36 problem resulted in the below. The display was from the 64bit version of the Process Explorer program (www.sysinternals.com though now a part of Microsoft at http://technet.microsoft.com/en-us/sysinternals/default.aspx). HTML clipboard 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...