Results 1 to 10 of 10

Open newly created macro from new workbook

Threaded View

  1. #1
    Registered User
    Join Date
    06-06-2010
    Location
    gloucester
    MS-Off Ver
    Excel 2003
    Posts
    6

    Open newly created macro from new workbook

    Hi everyone!! am a newbie to vba but hoping that someone can help as have been struggling with this for the last couple of days. i have created a macro in workbook 'A' that copies data into a template on a new workbook(call it Workbook B). as part of this the first sheet also has a couple of buttons that can print data and do others tasks.

    The problem being now that once Workbook A has closed and i go to run the macro from Workbook B it has to reopen Workbook A again to perform the task.
    I have tried to add a procedure at the end of the original macro that will then copy it into the new workbook but it still tried to refer to Workbook A.

    Is there anyway that i can set the buttons in Workbook B to run macros only from ' This Workbook' ?

    ANY HELP WOULD BE GREATLY APPRECIATED!!!

    Thanks again
    Last edited by stubarso; 06-06-2010 at 02:44 PM.

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