This method will generate the code to drive that button. My work around is to programmatically iterate through all OLE objects on the sheet* and write code to the debugger, then include a button basically 'resize objects' on the sheet - with instructions on why this problem is occurring. I am intending to post my work around, however, it is not even close to ideal and I would much prefer a better solution. There is a lack of authoritative information on this problem online.
The only seemingly authoritative solution involves a MS patch (it was a 'hotfix' several years ago, though, so it doesn't seem practical for full deployment) and registry edits, which is not practical for my use case. Font.Size parameter but something which cannot be changed after the problem occurs, other than continually increasing the fontsize The fontsize change is NOT a function of the. It's a mess to read through and ultimately doesn't have a cohesive answer. This thread discusses a problem I've been having with ActiveX objects in an Excel spreadsheet.
