I have an encrypted Excel file with macros. It's run fine on several computers over time. Tonight I just installed Office 2007 on a new Microsoft Surface Go. I've meticulously copied over all my settings from another Win10 machine including enabling all macros, enabling all macros in my particular subdirectory, etc.
Yet the Surface Go refuses to execute macros. Turns out that if I eliminate the password encryption the Go will run macros, otherwise not.
Any ideas how to make the Go treat macros the same as other Win10 machines?
That's a good thought, but... First thing I did out of the box was kill S mode. The System panel now reports it's running Win10 Home. While loading various software though, I saw Microsoft would sneak the settings back into their store mode only, so I had to turn that off several times.
Possibly after taking it out of S mode, there are some sort of remnants floating about the internals of the OS that are not 100% normal Win10. Or not.