I have a user that lost his macros from an Excel Spreadsheet, and wanted us to restore them. He doesn't know where they were saved, or what they were called. I was going to search his drive for the macro file name, but I don't know if macros have a file name. Any help? Thanks.
Recorded macros are usually either stored in the workbook they were recoded in or in personal.xls.
Normally stored in
C:\Program Files\Microsoft Office\Office\XLStart
How are the macros activated? (Hotkeys, controls on the worksheet, custom toolbar/buttons).
Normally trying to activate the macro will give a message saying it cannot find the file where they are stored.
Either that selecting the properties of the control or editing the toolbar button will show the path to the macro file.