You can create a new workbook containing only the one sheet with
code like

ActiveSheet.Copy

This will create a new workbook with one sheet. The user can then
save that workbook in the normal manner.




"MarkN" wrote in message
...
Hello,

How can you save just the active sheet into a new workbook
(allowing the
user choose the location of the new workbook and add the
required filename)?
--
Any help appreciated,
MarkN