+ Reply to Thread
Results 1 to 4 of 4

Buttons: How to remove multiple copies

  1. #1
    Registered User
    Join Date
    05-08-2013
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2011 mac
    Posts
    44

    Buttons: How to remove multiple copies

    I suspect I've run one of my macros from a button and its actions have copied some of my buttons, with macros attached, multiple times onto the worksheet.

    How can I delete multiple buttons at once. I am using Mac OS Excel 2021. One thread suggested using Developer > Design Mode, but the latter does not appear on my Excel.
    Last edited by tays01s; 03-01-2024 at 11:43 AM.

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Buttons: How to remove multiple copies

    See the video about selecting forms.

    How to select multiple objects in Excel

  3. #3
    Registered User
    Join Date
    05-08-2013
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2011 mac
    Posts
    44

    Re: Buttons: How to remove multiple copies

    Thanks, very useful.

    Note: If you have a lot of buttons and a v. large file, delete the buttons in batches, then save otherwise, at least on a Mac, it crashes.

  4. #4
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Buttons: How to remove multiple copies

    Tks for the feedback, I have no Mac, glad to have helped.

+ 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. [SOLVED] ActiveX Buttons - Set Position Multiple Buttons
    By Logit in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-19-2023, 07:31 PM
  2. How to remove extra copies of the workbook showing in the vba project list
    By Osprey3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2023, 08:57 AM
  3. VBA to create multiple copies of a sheet, copies named based on list in other sheet
    By Parth007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2019, 02:40 AM
  4. [SOLVED] How to remove extra spaces from copies string from mail body
    By shukla.ankur281190 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-14-2015, 03:14 AM
  5. Add and remove data labels buttons
    By Jabba69 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-06-2014, 05:26 AM
  6. How can I insert multiple sets of option buttons (radio buttons) in Excel 2010?
    By mickwooduclan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2013, 10:01 AM
  7. remove custom buttons
    By DaScribe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-12-2007, 02:23 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