Option buttons have stopped working after upgrade to Excel 2021

[davidam]

Hello All,
I have a large worksheet that has many option buttons that have the function of changing a value at a location on the same sheet, for example:

Private Sub OptionButton10_Click()
Range("d387") = "No"
Range("q389").Select
End Sub

However, none of my option buttons works since I upgraded to 2021
The buttons are grouped. When is select Design Mode I am able to select a button and then look at its properties. I can see that the group designations are there, and it says that the button is enabled.
But they just don't work. I notice that, when in Design Mode, if I select a button, it will be correctly named in the address box, but the function box for every button says =EMBED("Forms.OptionButton.1","")
I am sure this was not there when I originally designed the worksheet.
Any suggestions?
Thanks,
David

 

[davidam]

First, I think the EMBED thing is probably normal, I don't know what this means and any comment would be appreciated.
But I have found something that is so annoying and ridiculous: I have been casting about trying to find an answer to this problem and I found one. This was from a different website.
I have a two monitor setup and I usually move the either the sheet or the VBA page to the smaller screen, depending on which one I am working on the most. Sure enough, when I moved the sheet to the larger monitor, the buttons all started to work again. Seems ridiculous that that small amount of functionality could not survive something as trivial as a screen drag!
Anyway,
Thanks