How do I remove protection from a shared sheet?

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

I want to take a shared sheet that is protected, make some changes to make it
my own and save to use on my computer. The person that created the original
sheet will not give me the password. Is there any way around this?
 
Course, another option is to copy the data in the sheet and paste to a new
workbook.

Copy again and paste special, formats to make it look the same. then, do
what you'd like on yoru new workbook...
 
By "worksheet" do you mean "workbook"?

Must be......you cannot share a worksheet.

You should be able to select all worksheets by right-click and "select all
sheets"

Then right-click on active sheet tab and "move or copy".

Select "create a copy" to a new book.


Gord Dibben MS Excel MVP
 
Back
Top