Show and Hide of UserForm and Excel Worksheet with Toggle Button and Command Button

Hi
I am currently having problems to Show and Hide UserForm and worksheet properly. When I open the workbook everything works fine. The Userorm opens and the Worksheet is hidden as I want it. When I click the Show Worksheet the worksheet appears. However when I click the Close UserForm the UserForm and Worksheet disappears completely!

I am very new to VBA.

Here is the code I am using:

Private Sub tglDashShowSheet_Click()
          'TOGGLE BUTTON ON DASHBOARD - TO SHOW WORKSHEET - WHEN EXCEL OPENS ONLY THE USERFORM WILL
          'VISIBLE - EXCEL SPREADSHEET IS HIDDEN
          If tglDashShowSheet.Value = False Then
          'VISIBLE IS SET TO TRUE IN PROPERTIES WINDOW
                    Application.Visible = False
                    tglDashShowSheet.BackColor = &H80FF&
          End If
          'IF SPREADSHEET OPTION IS SELECTED THE BUTTON BECOMES INACTIVE
          If tglDashShowSheet.Value = True Then
                    Application.Visible = True
                    tglDashShowSheet.BackColor = &H80FF&
          End If
 
End Sub
Private Sub cmdDashCloseForm_Click() 'HIDE USERFORM - DASHBOARD BUTTON
          
          ApplicationsData.Hide
                    
End Sub

Thanx

Re: Show and Hide of UserForm and Excel Worksheet with Toggle Button and Command Butt

Ok. Got that.

Thanx for the help so far . I really appreciate it.

Re: Show and Hide of UserForm and Excel Worksheet with Toggle Button and Command Butt

The users in the office will only use the Application. Not seeing the Excel Sheet at at all. once they have added the applicants i will then work with the WS. To make certian all validations has been done and that there are not duplicates etc.

Idee will be to do aal this while they are using the Application but i am not there yet with writing VBA Code.

As you saw in the workbook some of the stuff I have done but it will take to long to do all and then give them the Application.

Currently they are typing it directly into a Excel worksheet and it is chaos.

I will be coming back a lot to the forum as i carry on with this.

Thanx again.

Re: Show and Hide of UserForm and Excel Worksheet with Toggle Button and Command Butt

Yes.

Thanx i got it sorted. It is working now. Sorry misread your question