+ Reply to Thread
Results 1 to 3 of 3

ERROR Message This action won't work on multiple selections

  1. #1
    Registered User
    Join Date
    12-17-2019
    Location
    Des Moines, IA - USA
    MS-Off Ver
    Office 365
    Posts
    2

    Question ERROR Message This action won't work on multiple selections

    Using Excel for Mac on Office 365, I am trying to add a new sheet to a complex workbook. When I click on the + to add a new sheet, I get a popup message "This action won't work on multiple selections" and am unable to add a new worksheet. Additionally, I am able to copy but not paste values, text or data outside of the worksheet and receive the same error message. Has anyone heard of this issue and more importantly what is the fix?

    Alert Error.png

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: ERROR Message This action won't work on multiple selections

    Do you perhaps have GROUP mode selected (ie, you have selected more than 1 sheet)?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    12-17-2019
    Location
    Des Moines, IA - USA
    MS-Off Ver
    Office 365
    Posts
    2

    Re: ERROR Message This action won't work on multiple selections

    I have several sheets, but only one selected. I have tried selecting all and then unselecting all - still same issue.
    Last edited by AliGW; 12-18-2019 at 07:17 PM. Reason: Please don’t quote unnecessarily.

+ 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. excel vba runtime error 1004 "this action won't work on multiple selections"
    By aprildu in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-08-2023, 04:17 PM
  2. [SOLVED] Compile Error: VBA choosing multiple selections from PivotTable.
    By saudi_red_neck in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-30-2018, 10:24 PM
  3. Run-time error 1004: this action won't work on multiple selections
    By aprildu in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-08-2018, 12:50 PM
  4. [SOLVED] Work around for Run-time Error 445: Object Doesn't Support This Action (File Search)
    By JPDutch in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-05-2013, 08:48 AM
  5. Replies: 3
    Last Post: 05-16-2013, 06:08 AM
  6. Run-time Error Multiple Selections SpecialCells xlCellTypeBlanks
    By goss in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2012, 08:59 PM
  7. Highlighting Multiple Selections That Don't Beging With an Error
    By Pherion in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2009, 04:41 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