Save active sheet into new workbook

[Guest]

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)?

 

[Chip Pearson]

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.

 

[Guest]

Thanks very much, it's easy when you know how!!!!!
--
Thanks,
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.

 

[Guest]

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

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