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