Thanks Norman, worked a treat, i was just having trouble if someon
clicked the button to save the sheets twice i had all sorts of errors
i have added a time satmp as well as a date stamp so it won't throw a
error up if the file already exists in the folder!

Andrew thansks for your response too, it just wasn't quite what
needed to incorporate without writing a few more lines of code....i'
usless at it and it takes me ages with trial and error!

Regards,
Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=55314