Warning: Use of undefined constant result - assumed 'result' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 36

Warning: Use of undefined constant pagename - assumed 'pagename' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 46

Warning: Use of undefined constant pagename - assumed 'pagename' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 52

Warning: Use of undefined constant id - assumed 'id' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 54

Warning: Use of undefined constant count - assumed 'count' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 58

Warning: Use of undefined constant debug - assumed 'debug' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/sqlfunctions.php on line 184

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 449

Warning: Use of undefined constant pw - assumed 'pw' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/dynamic.php on line 515

Warning: Use of undefined constant result - assumed 'result' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/menu.php on line 3

Warning: Use of undefined constant type - assumed 'type' (this will throw an Error in a future version of PHP) in /data01/hpcsolut/public_html/howtofix/search.php on line 3
Global Macro workbook Excel 2007 2010
How to fix anything
 About Us | Which Computer? | Memory Stick | Copy File | Site Map | 
What is a Browser | Search Engine | Windows Explorer 


Search for :



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

©Copyright HPC Solutions Limited - All rights reserved (2012/13) .
Please note we do not accept any responsibility for errors occurring During Use of this site users follow instructions listed at their own risk.