This happened to me – to start with nothing happened when I clicked the custom menu button. In my case it was because I had followed the link to open a TAGS sheet but hadn’t saved a copy to my Google Drive. after I used File> Make a Copy I could add the custom menu to my copy of the sheet.