Mine is also in the workbook code.

The macro puts the path of the file in the title area. I guess its like
this: The file needs to be saved to set the path and therefore nothing
happens at opening since the file has not been saved.

It would be preferable to have the macro run automatically after save



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/