+ Reply to Thread
Results 1 to 11 of 11

Frame to overlap anything when expanded

  1. #1
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Frame to overlap anything when expanded

    Hello

    I have a frame which can be expanded and collapsed. I have another frame below it. When I expand the top frame, the bottom frame still sits on top of whatever I have within the top frame.

    Is there a way around this? Like 'Frame 2 - Send to back'

    Thanks

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Frame to overlap anything when expanded

    Can't you hide the bottom frame?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Re: Frame to overlap anything when expanded

    Don't know why I didn't think of this before, I'll just move the position of the frame with some code - simple

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Frame to overlap anything when expanded

    I was actually thinking of setting the Visible property of the frame to False.

  5. #5
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Re: Frame to overlap anything when expanded

    Norie, there will be 15 frames in total which the user will make their way through. I'd like to keep them visible

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Frame to overlap anything when expanded

    I thought the problem was that one frame was sitting on top of another meaning the 'top' frame was hiding/obscuring the 'bottom' frame.

  7. #7
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Re: Frame to overlap anything when expanded

    That is the problem, currently there are only 2 frames. When I 'open' the first frame, the frame beneath still shows on top of it so you can't see what's in the top frame. So I'll just move the second frame down when the first frame is opened

  8. #8
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Frame to overlap anything when expanded

    I'm a little confused, why don't you just position the frames at design time so that they are both visible and not interfering with each other?

  9. #9
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Re: Frame to overlap anything when expanded

    At design they are both visible, but they are also both 'closed'. When the form is in play, you can click an expand button which increases the height of the form and therefore shows you more controls within it.

  10. #10
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Frame to overlap anything when expanded

    Can you upload an example workbook?

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

  11. #11
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Re: Frame to overlap anything when expanded

    ..........
    Attached Files Attached Files
    Last edited by PDBartlett; 11-17-2014 at 06:26 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. sum 2 column contains frame where frame*24
    By eng.hussein.maher in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-22-2014, 04:03 PM
  2. [SOLVED] determine total overlap time when there are gaps in overlap (4 date ranges)
    By miriambender in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-12-2014, 11:58 PM
  3. Replies: 0
    Last Post: 08-14-2013, 11:21 AM
  4. displaying a frame that is behind/embedded with another frame
    By bhodge10 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2007, 10:23 AM
  5. How to attach legend frame to chart frame?
    By holg3r in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-07-2005, 06:41 PM

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