Macro
 

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

Macro
 

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" wrote:

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

Macro
 

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

"akphidelt" wrote:

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" wrote:

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

Macro
 

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" wrote:

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

"akphidelt" wrote:

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" wrote:

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

Macro
 

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" wrote:

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" wrote:

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

"akphidelt" wrote:

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" wrote:

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

Macro
 

No problem, thanks for the feedback!

"Tenaj" wrote:

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" wrote:

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" wrote:

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

"akphidelt" wrote:

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" wrote:

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