Command button to print

[math20]

Hi,

I have a excel spreadsheet report. This report has two drop down box one for the staff and the other for the months.

I use the drop down box to select my staff and see their report for the month. What I am trying to do is create two printing options either by using check box or options box and a command button to select to print one report, the current report I am viewing or print all the report for all the staff in the drop down box for the month selected without having to click each staff in the drop down box and then print them.

Is it possible? Can anyone PLEASE HELP me?

Thank you.

 

[shetlandbob]

yes its possible do you know VBA

Hint: Record Macro's of what you want to do, investigate the code and away you go!

Robert Cumming

http://www.consultantengineer.co.uk