hiding Rows and buttons/comboxes, over the rows
 

Hi

depending on what the user of my form chooses in a combo box, the shee
hides different ranges.

However I also want to hide the other combo boxes and form parts whic
is laying on top of this range. How can I do this

--
Ctec

-----------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=52474

hiding Rows and buttons/comboxes, over the rows
 

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