ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macros disappear in Excel 2003 (https://www.excelbanter.com/excel-programming/440656-macros-disappear-excel-2003-a.html)

ellen

macros disappear in Excel 2003
 
Macros I created using VBA code disappear in future sessions. They appear to
have been created initially in the Personal Macro Workbook

Gord Dibben

macros disappear in Excel 2003
 
Does Personal.xls not open when you start Excel?

Look for it under Unhide in WindowsUnhide.

Is it there?

If not, check out HelpAboutDisabled Items

Has Personal.xls been disabled?

If so, enable it and see if your macros are available.

And.................are you sure the macros were created in Personal Macro
Workbook?


Gord Dibben MS Excel MVP

On Mon, 15 Mar 2010 12:53:01 -0700, Ellen
wrote:

Macros I created using VBA code disappear in future sessions. They appear to
have been created initially in the Personal Macro Workbook




All times are GMT +1. The time now is 09:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com