Results 1 to 4 of 4

VBA Menu userform stays up hidden workbook

Threaded View

  1. #1
    Registered User
    Join Date
    07-30-2020
    Location
    Loveland, Colorado
    MS-Off Ver
    Office 360 ProPlus
    Posts
    3

    VBA Menu userform stays up hidden workbook

    I created a userform that is a menu that has a command button for each sheet in the workbook.

    I entered the code below and have gotten it where the menu will open with the workbook staying hidden however, even you click on the command button nothing happens. I need it to open the selected sheet so it can be edited while still keeping the menu open.

    I've searched through other posts on multiple sites and can't find a solution to make it work better.


    Private Sub CommandButton1_Click()
        ThisWorkbook.Sheets("Availabilty").Activate
    End Sub
    
    Private Sub CommandButton2_Click()
            ThisWorkbook.Sheets("Assignments").Activate
    End Sub
    
    Private Sub CommandButton3_Click()
        ThisWorkbook.Sheets("Daily Schedule").Activate
    End Sub
    
    Private Sub CommandButton4_Click()
        ThisWorkbook.Sheets("Sign-Up").Activate
    End Sub
    
    Private Sub CommandButton5_Click()
        ThisWorkbook.Sheets("Sign-Up Tracker").Activate
    End Sub
    
    Private Sub CommandButton6_Click()
        ThisWorkbook.Sheets("Gap Coverage Tracker").Activate
    End Sub
    
    Private Sub CommandButton7_Click()
        ThisWorkbook.Sheets("Control Schedule & Sign-Up").Activate
    End Sub
    
    Private Sub CommandButton8_Click()
        ThisWorkbook.Sheets("Help").Activate
    End Sub
    
    Private Sub Image1_BeforeDragOver(ByVal Cancel As MSForms.ReturnBoolean, ByVal Data As MSForms.DataObject, ByVal X As Single, ByVal Y As Single, ByVal DragState As MSForms.fmDragState, ByVal Effect As MSForms.ReturnEffect, ByVal Shift As Integer)
    
    End Sub
    
    Private Sub UserForm_Click()
    
    End Sub
    Last edited by RealJoshTodd; 08-17-2020 at 09:20 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. HIDDEN WORKBOOK? Excel Workbook Closes after Userform Submits
    By maraecole3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-01-2019, 10:41 AM
  2. Replies: 11
    Last Post: 07-07-2017, 10:46 AM
  3. [SOLVED] Need a macro that opens another workbook but stays in current workbook
    By shoes1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-28-2015, 08:44 PM
  4. Keep Application hidden when Userform and Workbook gets closed
    By knineistheboss in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2014, 06:09 PM
  5. [SOLVED] Closing a workbook with the menu hidden
    By grumpyguppy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-08-2014, 06:41 AM
  6. UserForm stays active when print preview is opened
    By brandonduginski in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2013, 01:03 AM
  7. VBA Function Vlookup data from Hidden sheet in hidden workbook
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2008, 11:22 PM

Tags for this Thread

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