Forum Discussion
Macros not saving
Hi everyone
I’ve created some macro’s recently to automate some tasks but for some reason when I reboot my laptop they aren’t visible in the Personal Macro Workbook. I’ve checked the excel folder in the User directory but there’s no workbook just a metadata file? Can anyone advise?
I’ve created some macro’s recently to automate some tasks but for some reason when I reboot my laptop they aren’t visible in the Personal Macro Workbook. I’ve checked the excel folder in the User directory but there’s no workbook just a metadata file? Can anyone advise?
1 Reply
- So there is nothing in %appdata%\Microsoft\Excel\XLSTART (type that into Windows Explorer's address bar and hit Enter)?
If you record a macro which you set to store in your personal macro workbook and subsequently try to close Excel, does it ask you to save that Personal Macro workbook?
