Consulting

Results 1 to 3 of 3

Thread: Hide the form on a worksheet

  1. #1

    Hide the form on a worksheet

    My teacher if I want to be hidden somewhere in the image below in red, what code should I write?
    Attached Images Attached Images
    • File Type: jpg c.JPG (131.2 KB, 5 views)

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Me.Hide
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Mentor
    Joined
    Dec 2008
    Posts
    404
    Location
    I think it's something like this (in UserForm module):
    [VBA]Option Explicit


    Private Sub CommandButton1_Click()
    Application.Visible = True

    Me.Hide
    ''or
    'Unload Me
    End Sub


    Private Sub UserForm_Activate()
    Application.Visible = False
    End Sub


    Private Sub UserForm_Terminate()
    Application.Visible = True
    End Sub[/VBA]
    Artik

Posting Permissions

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