Try to look here:
Where is the Excel Personal Macro Workbook Located? | wheatblog
I was running a macro, and all the sudden I was asked if I wanted to save the file I was working on. I said "No" to saving that file. Then, Exsmell closed out every open workbook including the Personal Macro Workbook. I did a file search, and the most recent version was yesterday. I have several hours of work today on that workbook. Where should I look to retrieve it?
HELP
Try to look here:
Where is the Excel Personal Macro Workbook Located? | wheatblog
Earlier I was very much in doubt, now I am not so sure anymore...
after some travail and head-banging, I recreated the script that I lost. I have learned a lesson. Just because you save a macro in the editor, you still have to save the personal macro workbook.
Like this thread? Share it with others