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:
- Neem een nieuwe macro op: Tools -> Macro -> Record new macro
- Select by "store macro in": "Personal Macro Workbook" and press "OK"
- Do something (eg select a cell)
- Press the stop button
The PERSONAL.XLS is now available in the projects list. You can delete the recorded macro.