And just to add to both Don and Gord's reply (again).

The reason you don't want to call the workbook you share with others
"personal.xls" is that if those users have any macros, they could have used that
name.

And excel will only allow one workbook with that name open at any one time. You
wouldn't want them to have to make a choice--or irritate them by having to close
their workbook before they could open yours.

carrera wrote:

If I record a macro and save it in Personal macros, will it still work if I
email the file to another person? I am going to make it that the macro works
when they click a picture on the worksheet itself.

What if I save the macro in that file and email it to someone....they will
be changing the name of the file, will that disable the macro?

--

Dave Peterson