Sheet and Workbook Protction

  • Thread starter Thread starter Corey Brock
  • Start date Start date
C

Corey Brock

Is it possible to copy a sheet that is say a "template",
and is protected, to a new sheet, and have the
protection "laws" apply to the new sheet?
 
Corey

Works for me in Excel97, 2002 and 2003 if the protected sheet is in a workbook
that is not protected.

Right-click on the sheet tab and "move or copy". Checkmark "create a copy"
and in the "To Book" select which book and where in order and OK.

Copied sheet in new book or same book is protected.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Merge Multiple workbook sheets into one workbook 0
Cell in new sheet should always refer to defined cell in another s 8
Is it possible to copywrite a workbook? Or other protection option 6
Copy sheet to different workbook 1
Code to format cells on several worksheets 2
Protect but Allow Edit Ranges in Multiple Sheets 6
Must I use IRM to protect an entire workbook? 1

Back
Top