I have created an Excel Macro and saved as Personal Workbook Macro. I can
then run the macro provided I don't close Excel completely. However, once I
close Excel and attempt to run macro it is no longer available.

You input as to what I am doing wrong will be greatly appreciated.

Thanks,