Prepopulating a dropdown list in excel
 

How do I do that? I tried in workbook.open but can't reference the object. I
tried in worksheet_activate event , but you have to change the sheet and go
back to the previous sheet to activate it. The worksheet doesn't have any
onload event. Any help would be greatly appreciated.
--
Nothing but .Net

Prepopulating a dropdown list in excel
 

Is there a specific reason why you can't reference the object from the
workbook_open event? The one thing to note when doing this is that you will
probably need to be explicit in your reference to the object, including the
sheet that it is on...

Barring that in the on open you could just select and de-select the sheets
you want, which would trigger the activate event for those sheets...

HTH

"Manny" wrote:

How do I do that? I tried in workbook.open but can't reference the object. I
tried in worksheet_activate event , but you have to change the sheet and go
back to the previous sheet to activate it. The worksheet doesn't have any
onload event. Any help would be greatly appreciated.
--
Nothing but .Net