I finally was able to get it to work. I had to save my spreadsheet as an .xlsm file.