Results 1 to 7 of 7

Show sheet when userform is shown hide Sheet when userform is closed

Threaded View

  1. #1
    Registered User
    Join Date
    10-20-2014
    Location
    Arkansas
    MS-Off Ver
    2010
    Posts
    41

    Show sheet when userform is shown hide Sheet when userform is closed

    I am trying to show sheet3 (named MCR (BLANK)) when ever the Userform1 is initialized and Hide the sheet when Userform1 is terminated.

    Tried the code below, but it did nothing, any help or direction would be greatly appreciated.

    Private Sub UserForm_Initialize()
    Sheets("MCR (BLANK)").Visible = True
    End Sub
    Private Sub UserForm_Terminate()
    Sheets("MCR (BLANK)").Visible =False
    End sub
    Attached Files Attached Files
    Last edited by CtrlAltDelete; 11-25-2014 at 04:08 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Show UserForm InkPicture in Sheet
    By nickwoowoo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-26-2017, 02:28 AM
  2. [SOLVED] Show UserForm when switch to a sheet Solved by : ?
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2014, 06:27 AM
  3. [SOLVED] Show results from a sheet in a userform
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2014, 12:25 PM
  4. [SOLVED] VBA Help - List show in userform's combo box from sheet
    By sa.1985 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2012, 08:33 AM
  5. UserForm to search sheet, show results on separate userform?
    By egemenkepekci in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2010, 01:06 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