Need macro to copy active sheet to a new workbook

[Bill_S]

My workbook is protected so the user is prevented from adding/delete sheets.
I need a macro that:

-unprotects the workbook
-copies the active sheet (as values) to a new workbook*
-reprotects the workbook
-activates the new workbook

*The reason I want the entire sheet copied and not just all cells, is
because the exact cell formatting and print formatting needs to be preserved
in the new workbook.

 

[Don Guillett]

The macro recorder is your friend. Try it and then post back for comments to
improve.