I have created an addin which will add a control to the Window Command Button of the WorksheetMenuBar.It will list all visible sheets in Workbooks that are not hidden in the active Excel Application.
Question: how to force the dropdown selection to always appear under the control?
At present I set the width of the control to 380 and the .DropDownWidth = 364 for the list. This makes the dropdown appear under the control at a screen resolution of 1024x768. Is there a property I have overlooked?
here is the addin: