Save active sheet into new workbook

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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

Thanks very much, it's easy when you know how!!!!!
--
Thanks,
MarkN


"Chip Pearson" wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>