+ Reply to Thread
Results 1 to 4 of 4

Create button that opens up other workbook

  1. #1
    Registered User
    Join Date
    08-02-2009
    Location
    Cambridge, England
    MS-Off Ver
    Excel 2003
    Posts
    10

    Create button that opens up other workbook

    I have a number of monthly worksheets and a separate annual worksheet. I would like to place buttons on the annual worksheet that when clicked will open up the necessary monthly sheet. I would prefer to use macros as oppose to hyperlinks.

    Can anyone help me crack this one?

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Create button that opens up other workbook

    Have you tried recording a macro yourself while opening the file of choice?
    Give it a try. The macro Recorder is your friend.

    After you create the macro, activate the Forms Toolbox, select the Command Button control and place a button on the worksheet (click and drag to create and size the button), the right click the button, choose Assign Macro and pick the appropriate macro. You may also edit the text on the button.

    If you have trouble post back

  3. #3
    Registered User
    Join Date
    08-02-2009
    Location
    Cambridge, England
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Create button that opens up other workbook

    Hi there,

    Yes I did try that but it didn't seem to work. I would just use a button as a hyperlink but as I have other buttons that activate macros this causes problems. Once you click the link it also activates/deactivates design mode which you then have to access before the macro buttons work again, defeating the potential time saving ability the H-link is supposed to offer

    Thanks for you help on the matter though. If you can think of anything else please let me know.

    Al

  4. #4
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Create button that opens up other workbook

    Try adapting this. It's very basic, no error checks/handling, checking if file or folder exists, etc. - don't have time to do more, but you can search.

    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)

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