Macros not saving

Copper Contributor
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?
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?