Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    open wbook without strat coe (2000)

    Secure method, please...how to open wbook without start code in workbook_open event, or other part in macro ?
    ...because i maintain pressed the uacse key on key bord during the operation but the code in workbook_open start in other case????!!!!!!!
    Here the code:
    Private Sub Workbook_Open()

    LOG_MATRICOLA = UCase(Environ("USERNAME"))
    GetFullName
    'LOG_MATRICOLA = UCase(Environ("USERNAME"))
    Worksheets("TABELLA").Range("P1") = ""
    Worksheets("TABELLA").Range("P1") = LOG_MATRICOLA
    AGGIORNAMENTO.Show
    Call Fill_COMBO
    Sheets("TEMPLATE_1").Visible = False
    Sheets("TEMPLATE_2").Visible = False
    'Sheets("TABELLA").Range("T1").Value = ""

    End Sub

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: open wbook without strat coe (2000)

    You can use code like this:

    ' Disable event procedures
    Application.EnableEvents = False
    ' Open a workbook
    Workbooks.Open "MyWorkbook.xls"
    ' Enable event procedures again
    Application.EnableEvents = True

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: open wbook without strat coe (2000)

    Suggestion ok!
    Work...

Posting Permissions

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