+ Reply to Thread
Results 1 to 3 of 3

Edit/Remove button from worksheet

  1. #1
    Registered User
    Join Date
    03-13-2011
    Location
    Minnesota
    MS-Off Ver
    Excel 2003
    Posts
    3

    Edit/Remove button from worksheet

    I've used the forms toolbar for the first time, was able to successfully create and assign a simple macro to a button on a worksheet, and now want to edit or remove the button from the worksheet.

    Everything I've tried simply results in the macro being executed

    I'm sure I'm going to say 'duh' when I get the answer, but how do I

    1. Change the text or other properties of the button, or
    2. Remove the button from the worksheet?

    Thanks in advance.

  2. #2
    Registered User
    Join Date
    06-02-2010
    Location
    n.ireland
    MS-Off Ver
    Excel 2007
    Posts
    91

    Re: Edit/Remove button from worksheet

    Hi,

    When you hover over the button,just right click and you will see your options then.

  3. #3
    Registered User
    Join Date
    03-13-2011
    Location
    Minnesota
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Edit/Remove button from worksheet

    I'm on a MAC.

    option/click selects the text to allow edit. 'Delete' when the entire contents are selected then removes the button.

    command/click provides a few more options (assign macro/format control/edit text/....)

    It's a 'duh'. Thanks..

+ 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