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