Results 1 to 6 of 6

Pop up message only on FIRST opening, and not to display again

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-15-2008
    Location
    Arizona
    MS-Off Ver
    Excel 2013
    Posts
    179

    Pop up message only on FIRST opening, and not to display again

    I have a pop-up message that Mac users need to see the first time they open the file, but it would be annoying to have that pop-up every time they open. How do I tell it to only run this code the first time they open the workbook?

    Private Sub Workbook_Open()
    
    #If Mac Then
    
     MsgBox "This program detected you are on a Mac computer. While I changed the code to mac-friendly code, some Macs still do not read the code to create your drop-down menus. If your drop-down menu items go on one line instead of each item on a separate line, then read the troubleshooting for Mac file."
    
    
    #Else
    
      'Do nothing
    
    #End If
    
    
    End Sub
    Last edited by dsrt16; 10-10-2018 at 05:30 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Opening a Workbook using a MsgBox, and opening another message box on close
    By Henk12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2015, 01:17 PM
  2. [SOLVED] I need a message box to open up and display a message before printing.
    By Bobp84 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-16-2012, 01:34 PM
  3. Opening file message when opening a file from an http address
    By The_Real_MerlinXL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2010, 12:33 PM
  4. Message Display - Upon Opening Worksheet
    By JennyW in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2006, 04:04 PM
  5. Opening an attachment of a message that has a message as attachmen
    By vetron in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2006, 02:20 PM
  6. [SOLVED] How can I display a message when opening an Excel File?
    By PeterM in forum Excel General
    Replies: 4
    Last Post: 11-01-2005, 04:09 PM
  7. Replies: 8
    Last Post: 03-20-2005, 03: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