Aug 19 2023 09:41 AM
Aug 19 2023 12:13 PM
If the answer to 1. and 2. is yes, the recipient should be able to run macros in the workbook. They may have to allow macros explicitly when they open the workbook.
Aug 20 2023 02:21 PM
After the transfer to a colleague failed, I tested the steps internally to another user here at home.
I created an email and attached the file that contained macros.
Then I opened the received file on the other computer, and looked for the embedded macros. Nothing there.
As I read the MS information, Microsoft now puts a note in all files sent over the internet such that macros cannot be accessed on receipt.
Aug 20 2023 02:52 PM
Macros from the internet will be blocked by default in Office explains how to enable macros that have been blocked.
Aug 21 2023 09:42 AM
Thanks for the link.
Things don't quite work as promised.
When I opened the file on the recipient computer, it did not display the warning "Security risk...."
So I had no opportunity to accept the risk from the embedded macros.
On both the recipient computer and on my own computer (where I created the file, and the macros work) the option to unblock the security is not offered. See image.