Macro not saving in Excel 2007

**sieepy** · 04-08-2009, 02:30 PM

Hi - I created a macro in Excel 2007 and saved it under Personal Macro Workbook. The macro runs on the excel files so long as I don't close out the workbook. Once I close out the workbook I lose the macro and have to recreate. What am I doing wrong?

Thanks
-Hanh

**royUK** · 04-08-2009, 02:41 PM

Can you see a PERSONAL.xlsb in the VB Editor?

**sieepy** · 04-08-2009, 02:55 PM

Good lord, I got it. Thanks!

**royUK** · 04-09-2009, 04:28 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save