+ Reply to Thread
Results 1 to 2 of 2

How do I add another button that reference the same worksheet

  1. #1
    Registered User
    Join Date
    01-09-2014
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    8

    How do I add another button that reference the same worksheet

    Hello,

    I am trying to create 2 button commands for one worktab; 1 will reformat the date and the other one will delete all info but the ones as of today. How do I do that?

    I created a button from the worksheet that reformates the date
    How do I create a second button that will delete all data but the current one?
    So far I created a module.. but Ho do I assign this module to the worksheet in question?

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: How do I add another button that reference the same worksheet

    You don't assign modules to worksheets and if you already have a button on a worksheet it doesn't mean you can't add another one, or another ten if you want.

    If you want the second button to do something different from the first then assign it to a different macro.
    If posting code please use code tags, see here.

+ 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] Button to change worksheet reference #2
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2013, 12:09 AM
  2. [SOLVED] Button to change worksheet reference
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-05-2013, 12:58 AM
  3. Making VLookup Absolute reference and deleting worksheet reference question
    By crowdx42 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2006, 12:45 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