SOLVED

Immediately close excel file afer open

%3CLINGO-SUB%20id%3D%22lingo-sub-1716556%22%20slang%3D%22en-US%22%3EImmediately%20close%20excel%20file%20afer%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1716556%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone!%20I%20have%20one%20excel%20file%20run%20with%20Macros.%20But%20sometime%20after%20open%20this%20file%20immediately%20close.%20I%20think%20something%20wrong%20with%20Macros.%20Who%20is%20an%20expert%20with%20excel%20can%20help%20me%20to%20resolve%20this%20problem.%20Thank%20you%20in%26nbsp%3Badvance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1716556%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1716591%22%20slang%3D%22en-US%22%3ERe%3A%20Immediately%20close%20excel%20file%20afer%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1716591%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F810266%22%20target%3D%22_blank%22%3E%40trungbucharest%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20VBA%20code%20has%20been%20protected%20with%20a%20password%2C%20so%20we%20cannot%20view%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1716805%22%20slang%3D%22de-DE%22%3ESubject%3A%20Immediately%20close%20excel%20file%20afer%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1716805%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F810266%22%20target%3D%22_blank%22%3E%40trungbucharest%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EYou%20can%20unlock%20the%20VBA%20project%20and%20possibly%20see%20whether%20it%20contains%20a%20time%20lock%20and%20change%20%2F%20delete%20this%20permanently.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EBut%2C%20the%20question%20here%20is%20not%20whether%20it%20is%20feasible%2C%20but%20rather%20whether%20this%20is%20also%20allowed.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EWith%20your%20permission%2C%20I%20could%20give%20you%20the%20following%20help...%20try%20to%20change%20date%20settings%20in%20your%20operating%20system%20to%20the%20date%20before%202020%20(maybe%20using%2001.01.2019)%20and%20then%20try%20to%20open%20the%20file%20again.%3C%2FSPAN%3E%20%3CSPAN%3EJust%20a%3CSPAN%20class%3D%22%22%3E%20simple%20little%20suggestion%20for%20a%20solution%20from%20me.%3C%2FSPAN%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1717221%22%20slang%3D%22en-US%22%3ERe%3A%20Immediately%20close%20excel%20file%20afer%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1717221%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Hans%20Vogelaar%2C%20Thank%20for%20your%20help%20but%20I%20am%20not%20a%20guy%2C%20who%20create%20this%20file%20and%20I%20dont%20have%20password%20for%20VBA%20code.%20Sorry%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1717226%22%20slang%3D%22en-US%22%3EBetreff%3A%20Immediately%20close%20excel%20file%20afer%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1717226%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%2C%20Thank%20you%2C%20your%20suggestion%20is%20work%20with%20the%20little%20problem%20with%20program%20antivirus%20and%20Office%20365%20because%20cant%20to%20connect%20with%20the%20server.%20But%20however%2C%20is%20work%20and%20I%20think%20this%20is%20only%20possible%20way%20in%20this%20case%20when%20I%20dont%20have%20password%20for%20VBA%20code.%20Thank%20you%20very%20much%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi everyone! I have one excel file run with Macros. But sometime after open this file immediately close. I think something wrong with Macros. Who is an expert with excel can help me to resolve this problem. Thank you in advance!

6 Replies
Highlighted

@trungbucharest 

The VBA code has been protected with a password, so we cannot view it.

Highlighted

@trungbucharest 

 

You can unlock the VBA project and possibly see whether it contains a time lock and change / delete this permanently.
However, the question here is not whether it is feasible, but rather whether this is also allowed.
 
With your permission, I could give you the following help... try to change Date settings in your operating system to the date before 2020 (maybe using 01.01.2019) and then try to open the file again. Just a simple little suggestion for a solution from me.
 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 
 

 

Highlighted

Hi Hans Vogelaar, Thank for your help but I am not a guy, who create this file and I dont have password for VBA code. Sorry !

Highlighted

Hi @Nikolino, Thank you, your suggestion is work with the little problem with program antivirus and Office 365 because cant to connect with the server. But however, is work and I think this is only possible way in this case when I dont have password for VBA code. Thank you very much !

Highlighted

@trungbucharest 

You should ask the person who created the workbook...

Highlighted
Best Response confirmed by trungbucharest (New Contributor)
Solution

@trungbucharest