Forum Discussion
Can't edit macros in Personal.xlsb
If I may add these suggested solutions...
It sounds like you’re having trouble saving changes to your Personal.xlsb file due to an error with a temporary file.
Here are a few things you can try to fix the issue:
- Make sure you have the necessary permissions to save files to the XLSTART folder. You can check this by right-clicking on the folder, selecting “Properties”, and then going to the “Security” tab.
- Try deleting any temporary files in the XLSTART folder that may be causing the issue. You can do this by going to the XLSTART folder and deleting any files that begin with “~$”.
- If the above steps don’t work, you can try resetting Excel’s settings by renaming the Excel15.xlb file. This file is located in the %APPDATA%\Microsoft\Excel folder. Close Excel, rename the file (e.g., to Excel15.old), and then restart Excel. This will reset Excel’s settings and may fix the issue.
Please note that editing the Windows registry can be risky and can cause problems with your computer if not done correctly. Make sure to follow the instructions carefully and only make changes to the specific registry keys mentioned in the article.
I hope one of these solutions works for you!
Good morning
I have the same problem with Excel (Ofiice family 365). I cannot edit or modify the macros I have created.
when I want to edit them, I get a silly message that says "cannot edit a macro in a hidden workbook. Show the workbook using the Show command".
My workbook is not hidden, I cannot open the "personal.xls" workbook, not found.
The "Show" command does not exist.
Since the transition to Windows 11, functions have disappeared and nothing can be found.
None of the solutions given on the forums work.
If you have any solution, Thanks
JP
In Excel, select File > Options.
Select Add-ins in the navigation pane on the left.
Select 'Disabled items' from the Manage drop down, then click Go...
Anything there that you can enable?
HansVogelaar There are no disabled items.
