Unable to get code to run a click event on workbook open

[taylog2]

Hi everybody,
I am trying to write a workbook_open macro that runs a command button event. I have seen a couple of solutions on this forum but still seem to be having problems.

Code is:-

Please Login or Register  to view this content.

And error message says

Run-time error '424'
Object Required

Is it because the command button is imbedded in sheet 1?
By the way I am using Excel 2003

Thank you in advance for any assistance

[Norie]

That code would only work with an ActiveX command button.

[taylog2]

Ok thanks for that perhaps I should look at this another way, the code I want to run when the workbook is open is:-
cmdNamesCombo.Clear

Please Login or Register  to view this content.

This populates a dropdown list in a combo box with all the range names on the sheet.
Unfortunately when you exit the workbook & go back in the list is empty which is why I used the code within a control button to repopulate, but it would be nice to do this automatically or even stop the list from disappearing.
I tried it in an active x control button but it returns a run time error 424 of "object required" am I missing something simple.

[Norie]

Where is that located and what type of combobox is it?

How about putting it in the Activate event of the worksheet the combobox is on?

The code below works if cmdNamesCombo is an ActiveX combobox.

Please Login or Register  to view this content.

This code will work with a Forms dropdown.

Please Login or Register  to view this content.