Forum Discussion
PeterNagy
Dec 14, 2023Copper Contributor
Excel Macros disappear from xlsm file
Hi, since a few days we are experiencing the following on several computers (we are O365 customers and Excel is always update automatically (Version 2311 build 17029.20068) with Excel: We are...
BongoPuffy
Jan 08, 2024Copper Contributor
This is the message I get when I try to record a new macro in the file, It will not accept the macro name regardless of the syntax....
KCU_123
Jan 08, 2024Copper Contributor
This is because you already have a macro named "Macro1" in your document, It is more likely that it is disabled for use at the moment for use. If you try naming to other names such as Macro_ABCD etc, you should be table to record a new one.
- BongoPuffyJan 08, 2024Copper ContributorNo still get that message when I give it an unique and valid name
- JazzTeaJan 08, 2024Copper Contributorwell, I first make sure the macro enabled excel file is working fine, either by open and repair or restore to a known good copy, then set task schedule to run macro every 30 mins, since Friday and this morning, I haven't see any crash yet.
By the way, the version I re-installed is 32bit Excel Version 2312.
TT- JazzTeaJan 08, 2024Copper Contributorsorry, just realised that I am replying to different problem.. Sorry.