Missing Personal Macro Workbook

[Jolyn82]

Hi all,

I have this macro which I need to save it in my Personal Macro Workbook. The first time I saved, it is able to run but I need to close the file first.

However, when I need to run the same macro again, I cannot run the macro. So I thought maybe last time I saved wrongly and I re-imported the macro & try saving to Personal Macro Workbook. However, there's an error saying that I cannot record a macro in Personal Macro Workbook because I need it to be opened.. (????)

I then tried saving a Personal Macro Workbook from my colleague and saved it to my XLStart folder. This allows me to record a macro in my Personal Macro Workbook. And everytime was fine.

But the next time I need to try it again, it doesnt work again!!! I open my Excel file which I want to run the macro but it doesnt work and I tried opening the Visual Basic Editor but Personal Macro Workbook Project is not even there. But the problem is if i open a NEW workbook and open the Visual Basic Editor.. the personal macro file is there and my macro is there!!! I do not know the reason y...

Can someone enlighten me??

Thanx alot!!
Jolyn