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
Bookmarks