<div>
Not sure why they're not saved in the PMW, but are you saving with xlsm format (rather than xlsx or xlsb)?<br />
<br />
If so, then when you re-open, Excel may throw a message bar above the format bar asking if you'd like to enable macros. &nbsp;Maybe you missed that. &nbsp;However, even if the macros are not active, the code should still be there for xlsm files.<br />

</div>


<div>
I just played with Excel last night and was able to save a test macro, and one I use regularly. &nbsp;I think the issue was that I didn't save the first one I created. &nbsp;I think I'm all set.<br />
<br />
Thanks.
</div>


<div>
I &nbsp;checked addins to confirm the personal workbook wasn't disabled as you suggested and it wasn't . &nbsp;So I opened a workbook, and saw the macros I had just created.<br />
<br />
I still don't know how to get the ones I created in excel 2003, however.
</div>


<div>
<div class="content wysiwyg-content">
I have been using macros in Excel 2003 for years, and every time I open a workbook they are there where I need them. &nbsp;Since I upgraded to Office 2010, however, I lost all the macros I created in 2003 and when I create new ones, though I ask that they be saved in the Personal workbook, they are gone when I log out of Excel. &nbsp;What happens to them?
</div>
</div>


I have been using macros in Excel 2003 for years, and every time I open a workbook they are there where I need them.  Since I upgraded to Office 2010, however, I lost all the macros I created in 2003 and when I create new ones, though I ask that they be saved in the Personal workbook, they are gone when I log out of Excel.  What happens to them?

Not sure why they&#39;re not saved in the PMW, but are you saving with xlsm format (rather than xlsx or xlsb)?

If so, then when you re-open, Excel may throw a message bar above the format bar asking if you&#39;d like to enable macros.  Maybe you missed that.  However, even if the macros are not active, the code should still be there for xlsm files.


I just played with Excel last night and was able to save a test macro, and one I use regularly.  I think the issue was that I didn&#39;t save the first one I created.  I think I&#39;m all set.

Thanks.

I  checked addins to confirm the personal workbook wasn&#39;t disabled as you suggested and it wasn&#39;t .  So I opened a workbook, and saw the macros I had just created.

I still don&#39;t know how to get the ones I created in excel 2003, however.

Can&#39;t save macros in Excel 2010

Can't save macros in Excel 2010

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.