Macro HELP!!

D

DP7

I created a macro by recoding my actions. I then attached the macro to a
toolbar button. The problem is when I run the macro in any other worksheet;
the macro keeps opening up the original worksheet. Is there a way to prevent
this? Do I need to post the code for the macro for further help?
 
P

Peo Sjoblom

When you record a macro you get the option where to save the macro,
select personal macro workbook from dropdown under Store in:
Then attach the button it to the personal.xls workbook macro
If you don't have a personal.xls you need to create it, best way might be to
re-record the macro again and this time select the personal.xls
Otherwise you need to record a dummy, store it in the personal.xls, press
Alt + F11, copy the code from the original workbook's macro module and paste
into the personal.xls macro module


Regards,

Peo Sjoblom
 
Top