Thursday 4 February 2010

Office VBA

Office VBA
Go into VB Editor and hit F2. This gives you the "contents" of each module.

Excel Developer Tab (Design Mode)
What if you are hacking an Excel spreadsheet and want to see the code behind a button? For some reason, the "Design Mode" button is inactive!

Look below the "Ribbon" to see if there is a "Security Warning" saying "active content has been disabled". Click on Options, and 1) Enable Macros and ActiveX, 2) Enable Links.

No comments: