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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bill_S" wrote in message
...
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.