+ Reply to Thread
Results 1 to 4 of 4

Delete all Form buttons except few

  1. #1
    Forum Contributor
    Join Date
    09-16-2014
    Location
    Hyderabad
    MS-Off Ver
    MS Office 2021
    Posts
    346

    Delete all Form buttons except few

    Hi all!!

    I have 6 Form buttons on my sheet and they are named (visible as) as "Macros", Consolidate", "Template", "Emp List", "Sheet Name", "Generate Individual Employee Worksheets".

    I want to delete 2 buttons named :"Sheet Name", "Generate Individual Employee Worksheets" from active sheet.


    Any help please.
    Attached Images Attached Images

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Delete all Form buttons except few

    If they are Forms buttons rather than Activex buttons then just right click them to select them and then hit delete - or Cut.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    09-16-2014
    Location
    Hyderabad
    MS-Off Ver
    MS Office 2021
    Posts
    346

    Re: Delete all Form buttons except few

    @ Richard

    I meant using vba code to delete them. Sorry, I wasn't clear in asking earlier.

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Delete all Form buttons except few

    Hello Ravana,

    This should work for you...

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ 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. Delete Form Buttons on ClearContent
    By ExcelWizards in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-31-2013, 12:48 PM
  2. Mix up of buttons in Excel Add-In ribbon - how to delete buttons?
    By lausianne in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-11-2013, 08:51 AM
  3. Delete Form Control Buttons in a range on worksheet
    By abhiD in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 01-20-2012, 01:38 PM
  4. Are form buttons in a cell?
    By dmt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-02-2011, 06:57 AM
  5. Assigning backspace and delete to form buttons
    By solnajeff in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-03-2010, 09:32 AM
  6. Formatting Form Buttons
    By MGT2000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2008, 03:10 AM
  7. form/subform with buttons
    By BAZ in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-09-2006, 12:25 PM
  8. Form Buttons Not Working
    By SS in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-11-2005, 09:06 AM

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