Macro

[Tenaj]

Is there a way to create one marco in a way that I can use it in multiple
workbooks?

 

[akphidelt]

When you go to record a new macro... it will give you an option that says

"store macro in"

Select "Personal Macro Workbook"

That should save it and allow it to be used by all workbooks.

 

[Tenaj]

I did that but couldnt figure out how to get it to work in other workbooks.

 

[akphidelt]

After you save it in your personal macro book you should be able to open up
another excel workbook... go to

Tools--> Macro --> Macros

And you will see it listed in the Macro box.

 

[Tenaj]

After I closed my personal macro book and reopened it now it does show up in
the other work books. Thank you so much

 

[akphidelt]

No problem, thanks for the feedback!

After I closed my personal macro book and reopened it now it does show up in
the other work books. Thank you so much