Forum Discussion
New to Excel and cant save document due to Macros?
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
To save with macros select macro-enable format (.xlxm) from the file type list.
To enable Developer check it in File->Options
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.
