danglading
First Post
I don't really update the Excel spell sheet generator anymore as all of its functionality has been integrated into my PDF Character Record Sheet and most of it has been improved upon. The Excel is still notably faster though, but that is really the only thing I feel that is still better about using the Excel than the PDF. Okay, that is a bit besides the point, I just want you to know that you are probably best off using the PDFs found on DMs Guild.
What you are describing is indeed not how the sheet is supposed to work. As soon as you select a class, the button's caption should change. As this is apparently not happening, the macro must no longer be able to see the correct cell's content. Did you by any chance copy/paste/cut something into or out of the cell where you are supposed to select the class? I just downloaded the Excel and opened it and could add a subclass without any problems.
Alternatively, this could be related to the language of your Excel as Excel is notoriously bad at being language-independent. Which version of Excel 2016 do you run and what language? You can find both answers under File >> Account.
I used the most up-to-date pdf on Sunday evening and, other than the time delay, the generated spell sheet worked great. That was for a level 9 cleric, straight from the PHB. My initial trouble was for a different character, who is a multi-class Sorcerer Warlock. I have not yet tested that character on the new pdf because the latest UA (Revised Class Options, with the Celestial Warlock Patron) is not included in the assets as of yet. (Which I why I was trying to add the custom subclass to the Excel.)
So, to your questions: Regarding what version/language of Excel, it's a brand spanking new (as in: installed & activated minutes before the issue occurred) copy of Excel 2016, American English. So I doubt language is the issue. I don't remember pasting anything into the Class cell, but I'm pretty sure I typed into it before realizing I should have selected a class with the drop-down. It's entirely possible this messed up my file. I thought I already thought of this by starting over with a new copy of the file, but I lost track of everything I tried. Based on your suggestion, I just grabbed a brand new copy of the file and tested things, and it seems to be working properly. I probably borked the Class cell, as you suggested. Thanks!
I'm definitely interested in trying to get the newest UA content into the pdf, and I know you have some FAQ information on how to do that, but I have not yet had the opportunity to try to figure it out. I have no training in computer programming of any sort, so I'm going to be winging it unless someone beats me to the punch and creates that content for me. Regardless, thanks for the feedback, and thanks again for all the amazing work you put into the file.