Put the macro in a general module with a different name such as AddPath

In the BeforeSave event in the workbook module put in code like

Application.Ontime Now + TimeValue("00:00:05"),"AddPath"

--
Regards,
Tom Ogilvy



"hke" wrote in message
...
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/