+ Reply to Thread
Results 1 to 3 of 3

Display Alerts False (not working on Mac computer)

  1. #1
    Forum Contributor
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    MS Office: Excel 365
    Posts
    163

    Display Alerts False (not working on Mac computer)

    Hi --

    I have a code that I'm trying to make Mac compatible, and one of the functions in th ecode is to remove dupicates.
    When on a PC it works perfectly, but on a mac, a dialogue box pops up to asking that we 'ok' the column list for the remove duplicates function.

    Is there a way to have this alert not pop up when running on a mac (it already doesn't if on a PC).

    The code begins with 'Application.DisplayAlerts = False', so I'm wondering whether there's an equivalent/different function I should be using if the user is on a Mac.

    Thanks!

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Display Alerts False (not working on Mac computer)

    I'm not sure if there is a "remove duplicates" function built into Mac (or earlier versions of Windows) Excel.

    Which version of Mac Excel are you using?
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Contributor
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    MS Office: Excel 365
    Posts
    163

    Re: Display Alerts False (not working on Mac computer)

    It says Version 16.16.3
    Last edited by AliGW; 10-18-2018 at 10:11 AM. Reason: Unnecessary quotation removed.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Display Alerts
    By cassiopea in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-21-2010, 10:46 AM
  2. Display Alerts False and Follow Hyperlink
    By Davenumber40 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2009, 01:16 PM
  3. Display Alerts
    By venkia in forum Excel General
    Replies: 4
    Last Post: 10-18-2007, 09:57 AM
  4. display alerts via VBA
    By mikerickson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2007, 12:20 AM
  5. Display Alerts
    By MarkN in forum Excel General
    Replies: 0
    Last Post: 06-07-2006, 10:15 PM
  6. [SOLVED] Display Alerts
    By BEEJAY in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2006, 04:00 PM
  7. Display alerts
    By ewan7279 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2006, 08:50 AM
  8. [SOLVED] Display Alerts
    By Jason Zischke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2006, 03:35 AM

Tags for this Thread

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