The PERSONAL.XLS is not by default present in the VBA projects list in the Excels Visual Basic Editor. The method below presents a way to get this sheet:

  1. Neem een nieuwe macro op: Tools -> Macro -> Record new macro
  2. Select by "store macro in": "Personal Macro Workbook" and press "OK"
  3. Do something (eg select a cell)
  4. Press the stop button

The PERSONAL.XLS is now available in the projects list. You can delete the recorded macro.

  • No labels

Disclaimer