You most likely picked store in "this workbook" when recording the macro.

When that workbook is closed, your macro will not be available for other
workbooks.

Can you find the recorded macro?

Where is it?

We don't know what the instructions you found consist of.

Could you post them?


Gord Dibben MS Excel MVP

On Mon, 20 Apr 2009 13:13:03 -0700, AlwaysQuestions
wrote:

I have recorded a macro to open up a service report I use all the time. I am
able to open it only when I open Excel for the first time. After I close
that worksheet, I am not able to use the macro again.

There were some instructions I found about where to save but that did not
help.

What do I need to do?

Any help would be greatly appreciated!