Sep 10 2020 06:28 PM
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
Sep 11 2020 06:16 AM
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.