How to fix anything

Search for :


Google this page is not a duplicate


Global Macro workbook Excel 2007 2010

To make a Macro available to all your Excel Spreadsheets save it in the following:-

Early Versions of Office Loaded All Macros in the folder %appdata%\Microsoft\Templates\ folder


Windows XP Excel 2010

%appdata%\Microsoft\Excel\XLSTART\PERSONAL.XLSB


If this file opens every time you Open Excel then do the following:-

Open Excel
Click the VIEW Tab
Click Hide
Close Excel
Click Save

Now when you open Excel it will open Book1.xls

Windows 7 Excel 2010

%appdata%\Microsoft\Templates\PERSONAL.xltm

A Macro Enabled Worksheet

    IP