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!
--
-
Hi,
I have the following problem, when I create some dropdown boxes via
VBA then all 99 ones have the some height and length in the excel
sheet. But when I save the file and open it again, then some of the
dropdown boxes are smaller or bigger then before. Has anybody a good
idea? Thank you
Code: