Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Excel tool with vba

  • 01-09-2018 10:55PM
    #1
    Deco99
    Registered Users, Registered Users 2 Posts: 1,642 ✭✭✭


    I've been checking online but can't find much. I've an Excel worksheet using alot of vba. I've a Run page which contains the command buttons to do the various tasks. Is there a way to keep the initial run tab visible at all times in 20% (roughly) of screen while the various tasks are run using vba in the buttons and showing the other tabs in the remaining 80% of excel sheet.


Comments

  • #2
    Deco99
    Registered Users, Registered Users 2 Posts: 1,642 ✭✭✭Deco99


    Maybe a simplified way of putting it I want to keep a constant dashboard whilst the user works between tabs on a worksheet.


  • #3
    pillphil
    Registered Users, Registered Users 2 Posts: 793 ✭✭✭pillphil


    Is this a userform you want to keep "Always on top"? This worked for me if so.
    https://www.mrexcel.com/forum/excel-questions/511930-difficulty-vba-always-top-post2527477.html#post2527477

    If not could you do a screenshot or diagram or something?


  • #4
    pillphil
    Registered Users, Registered Users 2 Posts: 793 ✭✭✭pillphil


    Actually, on rereading, I don't think that's what you wanted. Do you want one part of one tab to be displayed while navigating through the other tabs?



  • #5
    Deco99
    Registered Users, Registered Users 2 Posts: 1,642 ✭✭✭Deco99


    pillphil wrote: »
    Actually, on rereading, I don't think that's what you wanted. Do you want one part of one tab to be displayed while navigating through the other tabs?


    Yes I think this may be closer, but I may put them above each other. I'm wondering if there are any issues with this, but only one sure way to find out. I'll report back


Advertisement