+ Reply to Thread
Results 1 to 2 of 2

hiding Rows and buttons/comboxes, over the rows

  1. #1
    Forum Contributor
    Join Date
    10-03-2005
    Posts
    183

    hiding Rows and buttons/comboxes, over the rows

    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?

  2. #2
    Tom Ogilvy
    Guest

    RE: 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
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1