PLEASE HELP! I cant save or close my document due to Macros and VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-1655763%22%20slang%3D%22en-US%22%3EPLEASE%20HELP!%20I%20cant%20save%20or%20close%20my%20document%20due%20to%20Macros%20and%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1655763%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20please%2C%20the%20excel%20sheet%20Ive%20been%20working%20on%2C%20I%20was%20told%20by%20my%20boss%20to%20add%20tick%20boxes.%26nbsp%3B%20I%20googled%20how%20to%20do%20this%20and%20needed%20to%20check%20the%20tick%20box%20tab%20(inside%20the%20Developer%20tab).%26nbsp%3B%20I%20did%20that%2C%20and%20then%20tried%20adding%20a%20couple%20of%20rectangular%20shapes%20as%20well%20in%20the%20top%20to%20add%20some%20headings.%2C%20That's%20when%20all%20the%20issues%20started.%20So%20I%20googled%20what%20I%20did%2C%20and%20I%20believe%20I've%20e%20added%20VBA%20(somehow)%20and%20that%20has%26nbsp%3B%20changed%20my%20spreadsheet%20function.%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20I%20really%20want%20now%20is%20a%20blank%20spreadsheet%20to%20start%20again%2C%20but%20I%20cant%20get%20out%20of%20this%20one%2C%3C%2FP%3E%3CP%3EI%20keep%20getting%20an%20error%20message%20saying%20%22reference%20not%20valid%22%26nbsp%3B%20-%26nbsp%3B%20no%20matter%20what%20I%20do%20that%20message%20comes%20up%2C%20I%20cant%20even%20close%20the%20document%20as%20it%20comes%20up%20that%20I%20cant%20save%20or%20close%2C%20because%20I%26nbsp%3B%20have%20macros%20enabled%2C%3C%2FP%3E%3CP%3EI%20tried%20to%26nbsp%3B%20go%20back%20into%20the%20developer%20tab%20to%20disable%20macros%20(%20or%20try%20to%20do%20something%20)but%20any%20and%20all%20options%20in%20the%20ribbon%20are%20greyed%20out.%20The%20tabs%20are%26nbsp%3B%20there%2C%20but%20none%20of%20the%20functions%20can%20be%20clicked%20on.%20.%20Even%20the%20options%20tab%20itself%20is%20greyed%20out.%26nbsp%3B%20I%20literally%20cannot%20change%20add%20or%20save%20or%20even%20close%20the%20document%2C%20All%20of%20it%20is%20greyed%20out.%20I%20cant%20even%20start%20a%20new%20one%3C%2FP%3E%3CP%3EPLEASE%20HELP%20ME%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1655763%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I need help please, the excel sheet Ive been working on, I was told by my boss to add tick boxes.  I googled how to do this and needed to check the tick box tab (inside the Developer tab).  I did that, and then tried adding a couple of rectangular shapes as well in the top to add some headings., That's when all the issues started. So I googled what I did, and I believe I've e added VBA (somehow) and that has  changed my spreadsheet function. 

All I really want now is a blank spreadsheet to start again, but I cant get out of this one,

I keep getting an error message saying "reference not valid"  -  no matter what I do that message comes up, I cant even close the document as it comes up that I cant save or close, because I  have macros enabled,

I tried to  go back into the developer tab to disable macros ( or try to do something )but any and all options in the ribbon are greyed out. The tabs are  there, but none of the functions can be clicked on. . Even the options tab itself is greyed out.  I literally cannot change add or save or even close the document, All of it is greyed out. I cant even start a new one

PLEASE HELP ME  

0 Replies