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