Need macro to copy active sheet to a new workbook

  • Thread starter Thread starter Bill_S
  • Start date Start date
B

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.
 
The macro recorder is your friend. Try it and then post back for comments to
improve.
 
Back
Top