Hosted on MSN

I built my own Excel toolbar using basic VBA, and it works in every spreadsheet I open

Annoyingly, many of the tools I use most in Excel aren't available as single-step commands in the ribbon or Quick Access Toolbar (QAT). That's why I built a personalized command layer that works in ...
The Windows Club

Enable or disable Trust access to Visual Basic Project in Office apps

If you want to enable or disable Trust access to Visual Basic Project in Office apps, such as Word, Excel, PowerPoint, etc., you can do so with the help of the built-in option, Local Group Policy ...
Visual Studio Magazine

Automate Microsoft Excel with Visual Studio 2010

Enhancements in the .NET Framework 4 and Visual Studio 2010 make Office automation solutions easier than ever to write and deploy. Here's an Excel automation scenario that reflects solutions that I've ...
Computerworld

Now’s the time to prep for Microsoft’s Excel macro crackdown

Though Microsoft has backed off earlier plans to block unsafe macros in Excel documents, that change is still coming. Here's what to do now to stay secure. On July 8, Microsoft pulled back from its ...