Inside Microsoft Excel

Make your macro available in every workbook

Inside Microsoft Excel

by Stephen Nebel

In the companion article titled “Stop hidden rows from fouling up your formulas,” the hide and unhide code was right in the Expenses.xls workbook itself. But you can make the macros available to every workbook by moving it into Personal.xls. You can then call the hide or unhide macros via a custom or customized Excel 2000-2003 toolbar or the Excel 2007-2010 Quick Access Toolbar.

The only thing you need to run the hide[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)