Need to open two macro excel files for macros to work
 

Hi folks. I put together 13 macros in one excel file ("file a"). Then
I renamed the file to "file b". Now, when I go to run the macros, it
requires that both files "a" and "b" be open. (I changed both files in
the meantime.) Any ideas as how I could get away with just having one
file open? Thanks for any help. Nigel.

Need to open two macro excel files for macros to work
 

Try putting/recording the macro's in the 'personal macro workbook' instead of
'this workbook'. They then should be available in any open workbook

"nigelbarham" wrote:

Hi folks. I put together 13 macros in one excel file ("file a"). Then
I renamed the file to "file b". Now, when I go to run the macros, it
requires that both files "a" and "b" be open. (I changed both files in
the meantime.) Any ideas as how I could get away with just having one
file open? Thanks for any help. Nigel.

Need to open two macro excel files for macros to work
 

Mark: thanks so much for this tip. Your suggestion put me on the right
path to the solution. Fixed! Nigel.