Tag Archives: Excel 2013

Excel 2013 Selection Colour and Theme Editor

If you ever want to change the way Excel highlights selected cells on a worksheet then you won’t have much luck scrolling through Excel’s options because, prior to Excel 2013,  it’s controlled by the Windows Appearance settings. In Windows 7 the setting can be … Continue reading

Posted in Microsoft Excel | Tagged , , , , , | 20 Comments

Recently Used Files Disappearing

The recently used files list is a really handy feature in Excel (and other Office applications) which allows you to quickly open workbooks which you’ve been previously working on and have saved. In more recent versions of Excel you can also … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , | 3 Comments

Determine the Office Edition in VBA

A few years ago a user asked how to use VBA to determine the edition of the active session of Office. I’m not sure why this would be useful (perhaps to show as information on a userform?) but I duly obliged … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , | 3 Comments

Installing Office 2013

Today I finally got round to installing Office 2013 Pro Plus (x86), Visual Studio 2012 Ultimate and SQL Server 2012 Enterprise Edition (x86). The order I installed them in is as listed because in the past I’ve found that installing Visual Studio … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , , , | 5 Comments

Excel 2013 Preview: New Worksheet Functions

Most of the new worksheet functions were listed in the last post which looked at changes in the Excel Object Model. To complete the list, the new worksheet functions which aren’t exposed in the WorksheetFunction class are: FORMULATEXT() SHEET() SHEETS() I … Continue reading

Posted in Microsoft Excel | Tagged , , | Leave a comment

Excel 2013 Preview: New Excel Object Model Members

I’ve cobbled together the below table of Excel Object Model members which have been introduced  between Excel 2010 (Office Professional Plus) and the Excel 2013 Preview (Office 365 Home Premium). Don’t worry, I didn’t spend hours manually trawling through the object browser to spot … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , | 3 Comments

Excel 2013 Preview: Microsoft Scripting Runtime Errors

One of the first pieces of VBA code I intended to write in Excel 2013 involved using a Scripting.Dictionary object. Unfortunately, subsequent to the Office 2013 installation, if I tried to create any object from the scrrun.dll library I got … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , | Leave a comment