Macros aren't working in Calc?

I created a spreadsheet last night with macros and everything was working fine. I try to edit it and a pop-up window appears giving me a warning about macros. So I navigated to Tools>Options>Security and changed Macro Security to low, and tried using it but it wouldn’t work. I closed and reopened the program and it still didn’t work. I tried other spreadsheets with Macros (also working previously) and they didn’t work. I checked all the macros, they are exactly as I left them.

What should I do?

Thanks in advance,
Brandon

Did closing completely, even rebooting, help?