[VBA V8i Ss2] MS_VBA_OPEN_IN_MEMORY not Working as Expected

I have not been coding In VBA for a while but some issues have come up and I find myself knee deep in the thick of things.

I have used this variable since being made aware of its existence and need. For administrators, it does complicate things, especially if we are not IT as well.

I need to keep my VBA's on a read/write location, so I set a default value of ALL in our standards but in my UCF, I set it to NONE. In the past, this worked. But lately, it seems to be retaining the ALL setting even for me. So I went into where we set it and added a test for username and only set it to ALL if the user is not me.

But it still complains of being read only. However, the title bar in the VBA IDE does not list read only. During certain operations, it will try to save the file, and report it to be read only and ask if I want to save it with another name. At this point, it allows my to write it back to its original location by clicking the OK or Save button on the dialog box. It will ask me if I am sure I want to overwrite the file and when I say yes, it does. In the past, I had found it necessary to save with a new name as it would tell me that file was read only.

Has anyone else seen this? TIA