+ Reply to Thread
Results 1 to 3 of 3

Delete & Create Buttons

  1. #1
    Registered User
    Join Date
    08-16-2007
    Posts
    50

    Delete & Create Buttons

    Hello All,

    I am trying to create two macros. One that deletes all buttons on a worksheet with the title "Choose Function", and another to create a button with the title "Choose Fuction" in each cell within a given range. For the delete button macro, I found some code online that seems to be doing something similiar and tried to customize it to do what I want, but it's not working. The code I've tried is:

    Please Login or Register  to view this content.

    For the create button macro, I used the macro recorder to get the following code, and it does add a button. But, I need to reference the button to a particular cell. How can I specify a location by referencing a particular cell?

    Please Login or Register  to view this content.
    If it helps, I attached the spreadsheet I've been using to test these.

    Any help on either of these issues would be greatly appreciated!

    Thanks
    Attached Files Attached Files
    Last edited by mcclanat; 05-22-2011 at 06:35 PM.

  2. #2
    Valued Forum Contributor mohd9876's Avatar
    Join Date
    05-04-2011
    Location
    Amman, Jordan
    MS-Off Ver
    Excel 2010
    Posts
    426

    Re: Delete & Create Buttons

    to delete the button modify your code as follows:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-16-2007
    Posts
    50

    Re: Delete & Create Buttons

    Thank you! That worked great. Also, I figured out how to add a button by cell reference. This code does what I was looking for:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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