Forum Discussion

DOlsen675's avatar
DOlsen675
Copper Contributor
Aug 10, 2023

Excel Macro

I wanted to clean up the macros and deleted the personal workbook (or it is hidden?) Now I cannot record macros

excel

1 Reply

Sort By
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Aug 11, 2023

    DOlsen675 

    1. Close all Excel windows
    2. Open Windows Explorer.
    3. Click in the address bar
    4. Type
      %appdata%\Microsoft\XLSTART
    5. Press Enter
    6. Move the workbook called personal.xlsb to a different location (or delete it if you wish)

    After this, you should be able to record macros to the personal macro workbook. If not, do a system-wide search for personal.xlsb and (re)move all copies to elsewhere.

Resources