I wrote code which creates and fills DropDown control when I double-click a cell (page 215).
It works fine in Excel 2007 with English UI, but it when I switch to Russian UI, then I get the following error (translation from russian to english):
Runtime error '1004': Unable to get DropDowns property of Worksheet.
Here's the code (the line with "With ActiveSheet.Dropdowns" is highlighted by compiler):
Private Sub GetWorkerName()
' Enter selected item into cell beneath DropDown.
' Delete DropDown.