Excel 2010 record macro default save to thisworkbook

J

John

I recently upgraded to Excel 2010 and now when I record a macro the defaultlocation for saving this macro is personal.xls. Is it possible to change that default to thisworkbook? I haven't found a way to change that default and would appreciate anyone's insight on how to do that. Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set as Default Template not working 0
Save workbook without shapes 0
Menu Macro Not Executing - Need Help 1
Setting column width in a table with a macro is not working 0
Word 2010: trouble saving font/size 9
Looking to flip text in Excel file (2010) 0
Is ExecuteExcel4Macro still works in Excel 2013 or later version? 1
Using XLM Macro Sheet in Excel 2010 1

Top