Hi Mike

However if she closes that workbook and uses
another then the macro isn't there.

Do you mean that you not see the personal.xls in the VBA editor then ?
Maybe the personal file is disabled

PERSONAL.XLS(B) will not open but is in the correct location

When Excel think the file is corrupt it can disable the file.
You can re-enable it here but if it is really corrupted replace it with a backup.

Excel 2002-2003: HelpAbout MS ExcelDisabled items
Excel 2007 : Office buttonExcel Options..Add-ins
In the "Manage:" dropdown (bottom of the dialog)
Choose "Disabled Items
Go






--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"mikebres" wrote in message ...
I have a coworker that I am trying to help setup to use Personal.xls for
storing her macros. I have tried a couple of different methods. I created a
meaningless macro and set the dialog to save it in My Personal Workbook, I
have gone into XLStart and created the workbook directly.
Then when she uses the macro while still in the first workbook where she
records it, it shows up. However if she closes that workbook and uses
another then the macro isn't there.
We are on a large corporate LAN, but then I haven't had any problems doing
this on my computer.

Does anybody have any ideas what I might be doing wrong?
Thanks
Mike