macro to produce paramterized customized printout

Hi

I am an experienced Java-Programmer with 0 experience in excel programming (well, my last macro programming experiments date back 20 years or so ... shocking ...).

I have a reporting-sheet with weeks as columns and projects as rows. Each project has a project manager.

Once a week, project managers meet and report their projects based on this sheet. To prepare, I have to filter out my projects (rows) and disable columns of past weeks (because excel cannot print unconnected areas). Then I can print the selection.

Now I want to automate this process as follows:
- select project manager
- select a range of weeks

-> the macro will filter-out the rows and disable unneccessary columns, then print the remaining, visible cells.

As I am complete newbee I need basic advice.

My approach would be to record a macro and then manually fill in the paramters, but I am unsure how to do so, especially regarding input facilities, dialogs or similar.

Thanks in advance and cheers,

Dostl_ba!

Thanks for the quick answer, nathansav,

I cannot download xls at work so I will check out your example this evening from home.

Cheers, Dostl_ba