G GN0001 Member Jul 14, 2012 #1 Hello Each time, I open the Excel workbook, it open personal.xls. How shoudld I get rid of that? Thanks for all. GN
Hello Each time, I open the Excel workbook, it open personal.xls. How shoudld I get rid of that? Thanks for all. GN
bobhc Excel Ninja Jul 14, 2012 #2 GGGGG When you start recording a macro, Excel asks where you want to store it. Your three choices are: current workbook, a fresh workbook, or your personal workbook. Personal.xls is the last choice; it's a single place to collect all your VBA code so it's available whenever you start Excel.
GGGGG When you start recording a macro, Excel asks where you want to store it. Your three choices are: current workbook, a fresh workbook, or your personal workbook. Personal.xls is the last choice; it's a single place to collect all your VBA code so it's available whenever you start Excel.
SirJB7 Excel Rōnin Jul 15, 2012 #4 Hi, GGGGG! Personal should have .xls extension (standard for 2003 version), .xlsb (idem for 2010), I don't remember what used 2007, but for last two .xlm should work too. Didn't checked, just assumed. Regards!
Hi, GGGGG! Personal should have .xls extension (standard for 2003 version), .xlsb (idem for 2010), I don't remember what used 2007, but for last two .xlm should work too. Didn't checked, just assumed. Regards!