View Single Post
 
Old 07-12-2021, 02:44 PM
wardw wardw is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Oct 2012
Posts: 65
wardw is on a distinguished road
Default Can't save macro; it's "in use by another application"

I've added a macro to VBA in the Normal project, so it will be saved in Normal.dotm. The macro runs in Word. When I try to save the macro, I get the message "This file is in use by another application or user. (C:\Users\wardw\AppData...\Normal.dotm)"

When I click OK in the message, a Save As dialog opens, suggesting I save the Normal.dotm file in the above directory. If I try to save it there, I'm told I can't replace the existing Normal.dotm file because it's read-only.

If I close Word to ensure that Normal.dotm isn't in use, of course the VBA app closes as well and loses the unsaved macro.

In the Normal.dotm file's Properties under Attributes, the Read-only box is not checked.

Is there a way to escape this seeming paradox?
Reply With Quote