Forum Discussion
Why is Excel macros sometimes missing ?
I have an excel file with a lot of rectangular shapes showing a tree structure for a family.
When the user clicks on one of the rectangulat shapes the 'story' of that person opens up in a Word dokument.
BUT ...
Most often the macro 'assigned' to the OnAction WONT run - instead this message comes up:
The macros is NOT shown when I "show macros" but it IS present in the VBA section when I press alt+F11 !
When it's working it's most often reight after a reboot og the machine - then it maybe works in 10-30 minuts and then the problem is back again !
I HAVE chesked the security setting allowing macros to be activated !
I have tha SAME file running under Window 10 for years WITHOUT any problems !!!!
I can see out there that people FOR YEARS have had similar problems with missing macros - but unfortunately I found no solution !
What the _BEEP_ is wrong here ?
8 Replies
It might be due to different versions of Word app. Try to open with the latest version.
Noone seems to have any ideas what to do to get further into curing this problem.
If I compile and save the file on a Windows 11 machine and try running a copy of THAT saved file (from Windows 11) on a Windows 10 machine the problem comes up there too !
(I just use a backup file to ensure my users can run on the Windows 10 machine again)
I run on fully updated Windows 10 and 11 and Office is too fully updated.
What the _BEEP_ is wrong here ?
THX for your replay !
I checked for updates on WORD and in fact there WAS an update ... and I started the updating !
I think it updates the whole MSOffice bacause I would update Excel but got a message that it already was updated.
Unfortunately is didn't cure the problem !
This morning I just COPIED the Excel-file from my Windows 10 machine (where it works nicely !) to the indows 11 machine ... oops ... a lot of macros then is missing in the menu but the ARE present in the VBA editor ... and they work there too !!
What the BEEP is wrong here ... and WHY does MS-staff not correct this fatal error ... missing macros hasd been a problem for YEARS !
THX for your reply, BUT ...
I'm pretty sure I have my updating set to updating ALL of my MS products ... but I'll look to be sure !
HALLOooooo out there !
Someone must have an idea what is wrong here !
Please tell me what I can do to make it work - WITHOUT any consequences for the function when the file is running under Windows 10 - bacause it works nicely under Windows 10 🤔
I've talked to people around and some told me they have had a similar problem in MSAccess and too in Excel ... ???
30-40 years ago the ONLY solution to some of the problems back then was "try making a new profile" !
Maybe we are at the same path here ... or ?
What the BEEP is wrong here - someone must have an idea what to do, but remember it works nicely running under Windows 10 !
Check the Excel Trust Center settings to ensure that VBA macros are enabled, save in .xlsm format, and update Office to the latest version.
As I wrote in my first posting - it's already done ... and it works SOMETIMES - I think that's spooky - right ?
