Recording a macro doesn't necessarily mean it will automatically be available
when you open Excel.

To make it available in all workbooks 'you' open you can save it in
personal.xls but you must tell excel to do this. If you are recording the
macro select personal.xls for the save location or if you are writing it
manually create the module in personal.xls.

If the macro is to be available when 'anyone' opens a particular workbook
then the macro must be in the workbook. If you want a toolbar button then you
will have to load that using something like the workbook_open event.

Mike

"hmm" wrote:

On more than one occasion, I recorded a new macro and assigned it a custom
toolbar button, only to have them both disappear when I next open Excel.

My question: when does Excel actually save new macros (in PERSONAL.xls) and
new toolbar buttons? Do I need to save after creating a new toolbar button,
and if so how?