Inside Microsoft Excel

View your worksheet code in a flash (2007/2010/2013)

Inside Microsoft Excel

by Kara Hiltz

For Excel users who tend to use macros and code frequently, Excel 2007, 2010, and 2013 can seem unintuitive. The Developer tab doesn’t even display by default unless you change the options specifically.

If it seems like you have to jump through hoops every time you want to see the code behind a worksheet, here’s a helpful tip: Just right-click on any worksheet tab and choose View Code from the shortcut menu, as[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)