Yes.

There are probably several ways you could approach it.
You could construct a userform to display a multiselect listbox with the
names of the columns.

It can be shown in the workbook_Open event or again, in a command button.

--
Regards,
Tom Ogilvy


"The Alltime Best" <alink5@stuurgeenspam.planet.nl> wrote in message
news:44551338$0$2025$ba620dc5@text.nova.planet.nl...
> 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
>
>