In my experience, adding forms directly to Excel sheets causes issues
like this to occur. The only fix I've discovered is the one you came
up with below (or similar approaches). You may find that focusing a
particular dropdown will cause the problem to reappear, in which case
you'll also need to
I fixed it, without finding the root cause:
Private Sub Workbook_Open()
For Each ws In Worksheets
For Each dd In Worksheets(ws.Name).DropDowns
dd.Height = 15
Next
Next
end sub
It is not a good way, but it works. If anybody has an idea what the
root cause ist, please post it!
--
-
