Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Refer to a specific outline in Excel (Excell 2000)

    I have a worksheet with five different data assumption input areas. I would like to be able to have the user show/hide individual areas using image icons on the worksheet next to each area. My first thought is to group each area and have the clicking the image collapse a specific outline; however, I do not know how to refer to specific outlines on the same level. Please let me know if you know how to do this or have another suggestion as to how to do this.

    I am self taught and my VBA skills are a bit clumsy, so specifics are appreciated.

    Thanks,
    Terry in Seattle

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Refer to a specific outline in Excel (Excell 2000)

    I think custom views may be a better choice. Check <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=76161&page=&v iew=&sb=&o=&vc=1#Post76161>this thread.</A> HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

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