Skip navigation

Category Archives: VBA

Determining a user’s security group in VBA

We’ve recently completed a project where we needed our add-in to behave differently depending on the security group of the user.  For example, if the user was an estimator, the add-in was to perform behaviour X; but if the user was clerical staff, the add-in should perform behaviour Y.

Read More »

Code Signing

Almost everyone who has used Microsoft Excel has seen the “Macros in this project are disabled” prompt.  It’s a mildly alarming message that is thrown up by members of the Microsoft Office suite, warning the user that there is some custom code in the document which could be dangerous.  In Excel 2007, the message looks something like this:

Read More »

Tables and Lists

I’m a firm believer in making use of features provided to make your life easier. I find it’s always best to start with the basics and learn additional features later on.  Since we’re talking Excel, things like macros and advanced formulas can take quite a long time to learn and build, and there’s no point spending time re-making something thats already been done, especially if its done better than your own implementation.

Read More »

Version Control in Excel

Early in 2010 we started using FogBugz, with the integrated Kiln.  In brief, FogBugz is an issue tracking tool, while Kiln is a version control system.  Version Control Systems (VCSs) help track releases and allows the ability to easily rollback to an earlier version. Kiln also allows teams of developers to merge their code.  To maintain our professional standard we needed a method to track versions and allow rollbacks etc, so we chose FogBugz and Kiln to give us this functionality.

Read More »

Creating Charts within a Chart in Excel VBA

Recently I had to find a way to add multiple additional charts to an existing chart. The original chart is already created and setup by VBA, we just want to add two small charts at the bottom of this one chart object.

Read More »