Redirect selection in cell to print job

[millawitch]

REDIRECT SELECTION IN CELL TO PRINT JOB

In spreadsheet_1 I'm creating several cells which contain drop-down menus so the user can select values from other spreadsheets in the same workbook (Excel 2003).

My issue is:

I would like the user to, once all data is selected, be able to print automatically the spreadsheet_1 AND all the spreadsheets selected in those cells with the drop-down menu when he selects print... Is it possible?

I'm new to programming and VBA, but I'm keen to learn!

millawitch

[6StringJazzer]

Yes, it's possible. But I'm not clear on how you have it set up to select the data from the other worksheets. The best thing would be to attach an example workbook. When you describe a "dropdown," is that a combobox control, or are you using data validation with a list?