Results 1 to 6 of 6

How get to code behind a custom button?

Threaded View

vbguy391 How get to code behind a... 10-27-2011, 11:30 PM
MarvinP Re: How get to code behind a... 10-27-2011, 11:35 PM
foxguy Re: How get to code behind a... 10-27-2011, 11:37 PM
vbguy391 Re: How get to code behind a... 10-27-2011, 11:51 PM
foxguy Re: How get to code behind a... 10-28-2011, 12:19 AM
MarvinP Re: How get to code behind a... 10-27-2011, 11:40 PM
  1. #1
    Registered User
    Join Date
    10-26-2011
    Location
    Durham, NC
    MS-Off Ver
    Excel 2000
    Posts
    5

    How get to code behind a custom button?

    I have a machine running Excel 2000 on WinXP. Every time I open any workbook in Excel there is a customized button that has been added to the Standard toolbar. I need to re-create what this button does in Excel on another machine. I know the button causes the execution of some macros located in various files.

    At first I tried finding a file that tells Excel about the customized button and supplies the code behind the button. I searched Excel.xlb and Personal.xls and I can find no macros for the buttons. There is nothing else in the XLSTART folder. I searched the c: drive for .xlt, .xltm, .xltx files and found none.

    When I look at the macros in a fresh workbook that has this button there are no macros and no VB code. How can I get to the code that executes when the button is clicked?

    Thanks.
    Last edited by vbguy391; 10-28-2011 at 01:14 AM.

Thread Information

Users Browsing this Thread

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

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