Hi
depending on what the user of my form chooses in a combo box, the sheet hides different ranges.
However I also want to hide the other combo boxes and form parts which is laying on top of this range. How can I do this?
Hi
depending on what the user of my form chooses in a combo box, the sheet hides different ranges.
However I also want to hide the other combo boxes and form parts which is laying on top of this range. How can I do this?
the shape object has a visible property, so set it to false in your code,
same as you are setting the hidden property for rows.
--
Regards,
Tom Ogilvy
"Ctech" wrote:
>
> Hi
>
> depending on what the user of my form chooses in a combo box, the sheet
> hides different ranges.
>
> However I also want to hide the other combo boxes and form parts which
> is laying on top of this range. How can I do this?
>
>
> --
> Ctech
>
>
> ------------------------------------------------------------------------
> Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
> View this thread: http://www.excelforum.com/showthread...hreadid=524742
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks