Excel Macro

Copper Contributor

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

1 Reply

@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.