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" 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

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" 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

What about saving copying the ActiveSheet into new Workbook as text i.e.
removing all forumla's so in essence you are doing a "paste special" with
values only?

I need help on this one!

Many thanks

Mark

"MarkN" wrote:

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" 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