in the attached file, I have used a VBA to adjust the width of drop-down list, even though the column is not as wide as the content of the drop-down list.
It works fine. But when I try to apply this to a more complex workbook, it doesn't work. I cannot attach this workbook, due to sharing-restrictions. However, my question is, is there a reason why this VBA wouldn't work on more complex workbook. For example, it has protected sheets. Can that cause a problem?
A bit annoying I cannot make it work - perhaps anyone has a better VBA to manipulate the drop-down list width?
Thank you very much!
Bookmarks