When I click enable editing a sheet disappear and result in error

%3CLINGO-SUB%20id%3D%22lingo-sub-2808307%22%20slang%3D%22en-US%22%3EWhen%20I%20click%20enable%20editing%20a%20sheet%20disappear%20and%20result%20in%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2808307%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20office%20365%20and%20I%20have%20received%20an%20excel%20file%20that%20includes%20macros%20and%20when%20I%20open%20the%20file%20it%20works%20and%20looks%20fine%20but%20when%20I%20click%20enable%20editing%2C%20some%20tabs%20disappear%20and%20result%20in%20%23Name%20error%20(below%20is%20a%20screenshot%20of%20the%20error%20message%20received%20when%20I%20click%20on%20any%20Macro%20button).%20Kindly%20advise.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22IbrahimSaid_0-1633340248304.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F314766iF13B571F6EA068B8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22IbrahimSaid_0-1633340248304.png%22%20alt%3D%22IbrahimSaid_0-1633340248304.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2808307%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2808625%22%20slang%3D%22en-US%22%3ERe%3A%20When%20I%20click%20enable%20editing%20a%20sheet%20disappear%20and%20result%20in%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2808625%22%20slang%3D%22en-US%22%3EI%20suggest%20you%20to%20contact%20the%20sender%20of%20the%20file.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2808650%22%20slang%3D%22en-US%22%3ERe%3A%20When%20I%20click%20enable%20editing%20a%20sheet%20disappear%20and%20result%20in%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2808650%22%20slang%3D%22en-US%22%3EI%20did%20already%20and%20they%20couldn't%20help%2C%20we%20checked%20with%20other%20colleagues%20and%20the%20file%20is%20working%20properly%20with%20them%2C%20we%20also%20noticed%20they%20are%20not%20using%20Office%20365%20(I%20don't%20know%20if%20this%20will%20help!).%3C%2FLINGO-BODY%3E
New Contributor

I'm using office 365 and I have received an excel file that includes macros and when I open the file it works and looks fine but when I click enable editing, some tabs disappear and result in #Name error (below is a screenshot of the error message received when I click on any Macro button). Kindly advise.

 

IbrahimSaid_0-1633340248304.png

 

4 Replies
I suggest you to contact the sender of the file.
I did already and they couldn't help, we checked with other colleagues and the file is working properly with them, we also noticed they are not using Office 365 (I don't know if this will help!).
I'd need the file to comment I'm afraid.
I'm afraid I can't share the file due to confidentiality agreement with the owners.