Thread: Macro HELP!!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Macro HELP!!

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

"DP7" wrote in message
...
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?