No problem Tim, glad its sorted. About this directory issue, you want t
change where its saved to? Ok, in the VBE select the ThisWorkboo
object and then go to the Open event.

Stick this code in the

With Application
.UserName = "John Doe"
.StandardFont = "Your font selection"
.StandardFontSize = "Your font size selection, in points"
.DefaultFilePath = "Where you want it saved to each time"
.AltStartupPath = "Your alternate startup path"
.EnableSound = False
.RollZoom = False
End With

This allows you to specify where you want the workbook saved each tim
by setting the Default File Path as soon as the user opens th
document.

Cheers

--
Message posted from http://www.ExcelForum.com