New to Excel and cant save document due to Macros?

%3CLINGO-SUB%20id%3D%22lingo-sub-1655639%22%20slang%3D%22en-US%22%3ENew%20to%20Excel%20and%20cant%20save%20document%20due%20to%20Macros%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1655639%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20am%20trying%20to%20work%20on%20Excel%20to%20create%20a%20simple%20roster%20type%20program%20(using%20excel%20was%20suggested%20by%20my%20boss%20even%20though%20I've%20never%20used%20it%20before)%20Anyway%2C%26nbsp%3B%20I%20have%20barely%20done%20anything%20on%20it%2C%20and%20tried%20to%20save%20it%2C%20but%20I%20keep%20getting%20a%20message%20saying%20I%20cant%20because%20Macros%20are%20enabled.%20I%20googled%20that%2C%20and%20it%20says%20to%20go%20to%20the%20Developer%20tab%20and%20disable%20Macros%2C%20I%20tried%20to%20do%20that%20but%20the%20Develop%20tab%20has%20all%20functions%20greyed%20out%20-%20so%20I%20cant%20change%20it%20-%20nor%20can%20I%20delete%20the%20work%20to%20start%20again.%26nbsp%3B%20Can%20someone%20explain%20what%20I%20need%20to%20do%20please%3F%3C%2FP%3E%3CP%3EI%20believe%20I%20must%20have%20inadvertently%20clicked%20the%20wrong%20box%20when%20I%20went%20into%20the%20Developer%20tab%20so%20that%20I%20could%20add%20tick%20boxes%20(this%20was%20the%20way%20suggested%20in%20a%20google%20link)%26nbsp%3B%20I%20don't%20know%20what%20else%20I%20could've%20done%20to%20cause%20this%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20help%20would%20be%20very%20much%20appreciated%20as%20I%20cant%20close%20the%20document%20to%20start%20another%3C%2FP%3E%3CP%3EMelanie%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1655639%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-1657198%22%20slang%3D%22en-US%22%3ERe%3A%20New%20to%20Excel%20and%20cant%20save%20document%20due%20to%20Macros%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1657198%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F789718%22%20target%3D%22_blank%22%3E%40Melaynee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20save%20with%20macros%20select%20macro-enable%20format%20(.xlxm)%20from%20the%20file%20type%20list.%3C%2FP%3E%0A%3CP%3ETo%20enable%20Developer%20check%20it%20in%20File-%26gt%3BOptions%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20776px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217754iF46FAEEA4B7B0741%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ETo%20remove%20all%20macros%20you%20may%20right%20click%20on%20any%20sheet%2C%20View%20Code%2C%20and%20delete%20here%20all%20code%20you'll%20find.%20Make%20a%20copy%20of%20the%20file%20before.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi I am trying to work on Excel to create a simple roster type program (using excel was suggested by my boss even though I've never used it before) Anyway,  I have barely done anything on it, and tried to save it, but I keep getting a message saying I cant because Macros are enabled. I googled that, and it says to go to the Developer tab and disable Macros, I tried to do that but the Develop tab has all functions greyed out - so I cant change it - nor can I delete the work to start again.  Can someone explain what I need to do please?

I believe I must have inadvertently clicked the wrong box when I went into the Developer tab so that I could add tick boxes (this was the way suggested in a google link)  I don't know what else I could've done to cause this 

any help would be very much appreciated as I cant close the document to start another

Melanie 

1 Reply
Highlighted

@Melaynee 

To save with macros select macro-enable format (.xlxm) from the file type list.

To enable Developer check it in File->Options

image.png

To remove all macros you may right click on any sheet, View Code, and delete here all code you'll find. Make a copy of the file before.