Macro doesn't work in new workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I create a new workbook with a macro and in the new workbook when I click on the button where my macro code is attached, it says it cannot find the macro. I know it is because it is looking for the macro and can find it because it is in the other workbook.
Thanks. Cecil
 
Hi
you may copy also the macro code to your new workbook and assign this
macro to your button.
 
Thanks, Fran
The macro code does go over already, but it is looking for the old workbook (compression*****.xls) and since I will not have it open, it can not find it. This new workbook will be open by someone other than me and a different computer. I have tried to put it in the personal project, but that too will not open in the new workbook. I was hoping that I wouldn't have to add a macro just to recopy and reattach the code.
Thanks Cecil
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable Macro Alert 2
How to copy a range of cells and paste into a new workbook in differentcolumns 3
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
problems getting this macro to work 23
Macro to push data to another workbook 0
Excel Protection 2
saving macro from workbook to Personal Macro Workbook 1
Macro Help 1

Back
Top