+ Reply to Thread
Results 1 to 2 of 2

Master Command Button to call on other Command Buttons located in other Workbooks

  1. #1
    Registered User
    Join Date
    02-05-2013
    Location
    Milton Keynes, United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Master Command Button to call on other Command Buttons located in other Workbooks

    Hello everyone

    I hope that someone can help me with this issue i'm having related to command buttons. The problem that I have encountered is that I now have a need to create a master Command Button for a series of other command buttons in a series of separate workbooks because someone else will be providing the maintenance for the report and the series of workbooks are contain sensitive information. I have created a workbook called "Report Control Sheet" where I want to have a master button that when clicked opens and actions the command buttons within 5 different workbooks, I have created everything except the code for calling the CommandButton in each workbook. I have been searching for the right code to use in VBA that would do this however everything I have come across hasn't worked. The other issue is that I haven't renamed the command buttons in each workbook and I don't know if this is causing an issue also?

    I'm a bit of a novice when it comes to this stuff as it is all self taught and any help or advice would be really appreciated.

    Nick

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,613

    Re: Master Command Button to call on other Command Buttons located in other Workbooks

    If the command buttons are ActiveX-type command buttons, try something like this...

    Please Login or Register  to view this content.
    The red is the file name of the already opened workbook
    The blue is the sheet code name (not the tab name) where the ActiveX command button is located
    The orange is the name pf the Command Button procedure.

    It wouldn't matter if the command buttons had the same name in different workbooks or worksheets.

+ Reply to Thread

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