Enable content closes file (Not all machines)

%3CLINGO-SUB%20id%3D%22lingo-sub-1800392%22%20slang%3D%22en-US%22%3EEnable%20content%20closes%20file%20(Not%20all%20machines)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1800392%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20several%20excel%20files%20and%20all%20with%20the%20same%20behind%20the%20scenes%20VBA%20%2F%20macros.%26nbsp%3B%20However%20for%20some%20reason%20when%20I%20started%20opening%20some%2C%20they%20would%20automatically%20close.%26nbsp%3B%20I%20could%20copy%20the%20file%20and%20open%20and%20NOT%20enable%20content%20to%20do%20some%20work%20but%20without%20the%20content%20enabled%20could%20not%20have%20full%20access.%26nbsp%3B%20Have%20found%20that%20others%20are%20not%20having%20the%20issue%20with%20the%20same%20files.%26nbsp%3B%20They%20are%2Fhave%20been%20opening%20the%20files%20and%20using%20%22as%20is%22%20with%20all%20content%20enabled%20and%20not%20running%20into%20any%20issues.%26nbsp%3B%20I.T.%20has%20already%20re-imaged%20my%20machine%20and%20is%20now%20saying%20there%20is%20nothing%20more%20they%20can%20do.%26nbsp%3B%20Given%20the%20issue%20is%20not%20occurring%20on%20all%20machines%2C%20sounds%20unlikely%20that%20the%20problem%20is%20with%20the%20file%2C%20but%20looking%20for%20some%20ideas.%26nbsp%3B%20Right%20now%20my%20only%20choice%20is%20to%20recreate%20all%20the%20files%20with%20no%20coding%20which%20means%20they%20will%20not%20be%20public%20as%20the%20coding%20is%20what%20was%20keeping%20some%20users%20from%20making%20changes%20%2F%20automatically%20hid%20some%20data%2C%20etc.%26nbsp%3B%20Without%20the%20coding%20we%20will%20have%20to%20be%20much%20more%20%22picky%22%20on%20who%20gets%20files%20and%20what%20they%20get.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1800392%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Have several excel files and all with the same behind the scenes VBA / macros.  However for some reason when I started opening some, they would automatically close.  I could copy the file and open and NOT enable content to do some work but without the content enabled could not have full access.  Have found that others are not having the issue with the same files.  They are/have been opening the files and using "as is" with all content enabled and not running into any issues.  I.T. has already re-imaged my machine and is now saying there is nothing more they can do.  Given the issue is not occurring on all machines, sounds unlikely that the problem is with the file, but looking for some ideas.  Right now my only choice is to recreate all the files with no coding which means they will not be public as the coding is what was keeping some users from making changes / automatically hid some data, etc.  Without the coding we will have to be much more "picky" on who gets files and what they get.

0 Replies