Jan 27 2023 06:06 AM
I have a few macros I created a while ago in my Personal.xlsb file. Recently I tried to edit one of the macros but it never works because it won't save the new personal.xlsb file. It gives me an error about some temporary file name it is trying to save to the xlstart folder. Below is a picture of the error message I get. Anyone see this before or know how I can fix it so that I can save my new macros?
Thanks for any help you can provide.
Joe
Apr 14 2023 10:45 AM
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
Apr 14 2023 11:02 AM
Apr 14 2023 11:58 AM
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?
Apr 15 2023 08:37 PM
@Hans Vogelaar There are no disabled items.
Apr 16 2023 02:08 AM
SolutionIf 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:
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!
Apr 17 2023 01:41 AM
Hello,
Thank you for these tips. I will try with caution.
I have already found a partial solution, but it is not satisfactory: if I create a macro for the open document, I can
modify it. But it cannot be used for new documents. So I will try the solutions you suggest and let you know;
Thanks,
JP
Apr 17 2023 06:57 AM
@NikolinoDE Thanks. It does look like it was a permissions problem. I tweaked a couple permission settings and now it looks like it is working. Thanks for pointing me towards a solution!.
Joe
Apr 17 2023 07:04 AM
Apr 16 2023 02:08 AM
SolutionIf 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:
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!