Forum Discussion
XLM Macros no longer able to edit at all?
After a lengthy Microsoft update today, I am unable to update an old XLM macro which has been working quite happily once a month up until now. I followed the instructions on the help as best I could ( there was no checkbox of 'Enable Excel 4.0 macros when VBA macros are enabled) selected Enable all Macros and allow Editing. The macro still won't run! I recorded this macro step be step many years ago and doubt if I can recreate it. HELP!!!
- Is that checkbox not there at all for you, or is it disabled?
At first you say you are not able to update the macro. But later in your message you say you cannot run it. What do you need to be able to do?
Can you post the macro steps? Perhaps it is easy enough to translate into a VBA macro.JKPieterse The option doesn’t come up for me at all. The macro isn’t very elegant and requires me to edit the date and a cash amount before I run it. It appears to allow me to edit but then won’t run.
- I don’t actually know how I could post the macro steps into this forum.
- Hi Jan
In case you have not noticed, we have extracted the three macos into a text file and have unfortunately attached the text in a reply to my own posts.
I trust you have access to that.
Apologies.
Frank- These macros look like they should be easily recorded using the VBA macro recorder. After that they would need a bit of tweaking to work as your xlm code works.
Alternatively, you could email the workbook in question (sanitized) so I can try to do that for you. Email address at the bottom of my website: https://jkp-ads.com
Please include a link to this discussion in you rmessage.
