Results 1 to 2 of 2

Compile error: Method or data member not Found

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    Compile error: Method or data member not Found

    i have that error here's my code.

    Anybody can help what's the problem ? thanks godbless.

    Private Sub UserForm_Initialize()
    
    Label1.Caption = ActiveWorkbook.Name & " Type the password to open"
    
    End Sub
    Private Sub OK_Click()
    If Me.Password.Value = "1234" Then
        Run "Sheet_visible"
        Sheets("TP & EDC").Activate
        Unload Me
    Else
        MsgBox "Wrong Password Please Try Again", vbExclamation, "Workbook Security"
        UserForm_Initialize
    End If
    
    End Sub
    Private Sub Cancel_Click()
    
    ThisWorkbook.Saved = True
    Application.ActiveWorkbook.Close
    End Sub
    
    Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
    
        If CloseMode = 0 Then
            Cancel = True
            MsgBox "The X is disabled, please use the button on the box", vbCritical, "Function Disabled"
        End If
    
    End Sub
    Last edited by jasond1992; 11-24-2015 at 11:15 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Compile error: Method or data member not found
    By aliciaward1001 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-26-2015, 04:11 PM
  2. Compile error method or data member not found
    By sureshpunna in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2014, 09:00 AM
  3. Compile Error Method or data member not found
    By ixelister in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2014, 03:39 PM
  4. [SOLVED] Compile error: Method or data member not found.
    By ndtsteve in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-10-2012, 11:31 AM
  5. Compile Error: Method of data member not found (VBA)
    By vbatech in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 03-14-2012, 05:37 PM
  6. Compile Error:Method or Data Member Not Found
    By loknath in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-29-2012, 04:03 AM
  7. Compile Error Method or data member not found
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2005, 06:05 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