Personal Macro Mystery

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

Guest

Hello I have a workbook - MePersonal1.xls - where I have recorded macros in
the past and I use these macros. I want to record a new macro but I do
not get the option to save it to this MePersoanl1.xls workbook. In the store
macro in - I only get the following options Personal Macro workbook - New
workbook - and This workbook this macro should be available to all open
workbooks . where and how should I save this new macro to? thanks
 
You are best off to place your macros in Personal Macro Workbook. This is a
workbook that is opened (but not visible as a regular workbook would be) by
default every time XL is opened and the macros will be available to all open
workbooks...
 
My choice is to record into a new workbook. (Make sure you save that workbook
when you've made changes you don't want to lose!)

Then when you're happy with the macro's behavior, you can copy the code from
that development workbook and paste it into a module in your "real" workbook.

I'd rather not take a chance that I'll screw up my good macros while playing
with one that isn't perfect.
 
Dave Thanks for the advice. will do

Dave Peterson said:
My choice is to record into a new workbook. (Make sure you save that workbook
when you've made changes you don't want to lose!)

Then when you're happy with the macro's behavior, you can copy the code from
that development workbook and paste it into a module in your "real" workbook.

I'd rather not take a chance that I'll screw up my good macros while playing
with one that isn't perfect.
Click to expand...
 
Back
Top