New to Excel and cant save document due to Macros?

Copper 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

@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.