What you're describing can be done with VBA.

If you only have a handful of visible row/column scenarios to display you
might want to consider using Custom Views. Each named Custom View will
retain its visible row/column conifiguration and print settings. Plus, you
could reconfigure/add/delete a Custom View without having to touch your code.

If the selections will be completely variable, though, then option buttons,
checkboxes, list boxes, etc make more sense.

I hope that helps.

***********
Regards,
Ron

XL2002, WinXP-Pro


"The Alltime Best" wrote:

> Hello,
>
> I have a question about the possibilities of Excel (in combination with
> VBA).
> Someone asks me to solve a problem and gives an idea for a possible solution
> along with it.
> I just want to know if that solution is possible.
> Thus I don't ask to solve this problem at this moment, but I only want to
> know if it possible in this way.
>
> Namely the following:
> One has an Excel-sheet with many columns and rows.
>
> If one starts the .xls-file, a dialog box appears with a couple of fields in
> it (easy until now).
>
> By this dialog box, one can choose (e.g. with drop-down menu's or so) which
> columns and rows one want to be visible after clicking the OK button. The
> idea behind this is that one always needs some columns and rows of a huge
> worksheet, but one wants to choose everytime which columns and rows that
> are. In this way one can see the desired columns and rows of that huge
> worksheet at a glance.
> If one is ready with filling in these cells, one clicks on an OK butten
> somewhere on the worksheet (e.g. at a taskbar) and the dialog box appears
> again to choose another set of columns and rows.
>
> Is this possible or not?
>
> Thanks,
> Boudewijn
>
>
>