Personal marco workbook

[Guest]

Hi any suggestion on how to retrieve back content of Personal marco workbook
that gone missing after excel crash. Thanks in advance

 

[Dave Peterson]

Are you sure it's not where it's always been?

xl2002+ has the abililty to quarantine what it thinks are bad workbooks.

They can keep track of them so that it doesn't even try to open them.

If you look under Help|About MS Excel, you'll see a button called: "Disabled
Items...".

Check under there to see if it's marked not to open. You can enable it there,
too.

If the workbook is really bad, you may want to delete that copy and put a copy
of your backup version into your XLStart folder.

===
If the workbook hasn't been disabled, maybe you can use windows start
button|Search to find that file.

Remember to look through hidden folders, too.

If you can't find it, you'll have to restore it from one of your backup copies.

 

[Guest]

Hi Thanks for your quick response. To be more precise, when i try to record a
marco in personal marco workbook. an pop up saying that this workbook is not
open and recording abort. Personal Marco Workbook is a unique workbook that
create by excel to store excel related VBA regardless of what excel workbook
do you working on or the marco in that folder is public throughtout excel
application.

Generally, when window startup this folder will be automatically open. Now
the ability to open it antomatically by window is missing. I am able to local
the folder as well as the workbook and need to open the workbook manually.
appreciated if there is a known method to turn on the auto function. Thank
again.

 

[Dave Peterson]

Did you check to see if the personal.xls workbook was disabled by excel?