how do i create a drop-down list using workbooks?

[Guest]

i need to create a drop-down list using the name of the workbook existing in
a folder, so i can select one of them and run a macro...i saw this action
once but i can't do it, i don't know where are these options...and when you
add a new file or workbook to the folder ir appears in the drop-down list in
excel...i think i had to use macros but i don't know how to perform this
operation....

 

[Guest]

two steps:

1. create a data validation list and a validation pull-down in, say, A1.
2. create a change event macro to monitor cell A1, and if it changes, use
the value to determine which macro to call