"Enable Editing" with VBA?

Have a look if there are any differences to the settings between those that show the "enable editing" message and those that don't under "File / Settings / Trust Centre / Trust Centre Settings / Protected View". That may explain why some work and this one doesn't.

Other than that, perhaps if the files are in different folders then some are "trusted locations" and some are not.

I'm not sure if you can bypass that message with VBA as any open event code (presumably) wouldn't fire until that message had been acknowledged.
I've never tried though, so could be wrong...

Beth.

I just checked my files again, the other one I'm opening from the network server is not VBA, it's just plain XLSX. It is definitely opening in Protected view because it's opening 'from the internet'. is there a way to disable that feature for the specific file? I didn't see it in the file when I was looking... And I don't want to turn off that feature for all files from the internet...

Whether or not you can switch this option off for a single file will very much depend on your network and how the admins have it locked down (if at all). Impossible for me to say I'm afraid.

You could ask your network admins to "digitally sign" the file. That would make it trusted and potentially not show this message upon open.

Other than that I'm out of ideas.

Beth.