+ Reply to Thread
Results 1 to 8 of 8

auto close msgbox

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    09-30-2010
    Location
    Minnesota, USA
    MS-Off Ver
    Excel 2010
    Posts
    109

    Re: auto close msgbox

    the message box was made with a form and is displayed instinly when you open the file and it states the General Information about this file for those who refference it's data. like my selef.

    This is the code that displays the message, but I can't change any thing in that file.
    and This code is located in the folder “Microsoft excel object” and named “ThisWorkbook”
    Private Sub Workbook_Open()
        'this activates the General Instructions Form when the workbook is opened
        
        ActiveWindow.ScrollWorkbookTabs Position:=xlFirst
            Sheets("Master List").Select
            frmGeneralInformation.Show
    End Sub

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: auto close msgbox

    Quote Originally Posted by CityMPLSEmpolyee
    Code I used was
    Application.DisplayAlerts = False
    Application.DisplayAlerts = True
    Is this the same thing?
    No.
    Application.EnableEvents = False
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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