Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy value from active sheet to another workbook | New Users to Excel | |||
Macro to copy active worksheet to new workbook | Excel Discussion (Misc queries) | |||
Copy and Remame Sheet in active Workbook | Excel Programming | |||
VB to copy a sheet to active workbook | Excel Programming | |||
VB Method to copy and save only one sheet of the active workbook | Excel Programming |