Workbook protected itself?? 2007

  • Thread starter Thread starter terryc
  • Start date Start date
T

terryc

I have a workbook with several worksheets that I've never protected. Today
when I opened the file it and attempted to rename a worksheet it says
"Workbook is protected and cannot be changed". I I try to enter a time into a
cell, I don't get the error message, but it doesn't accept my data. I don't
even know how to protect a workbook. Any ideas? Thanks.
 
Sounds like you have both workbook and worksheet protected.

On Ribbon go to Review>Protect Workbook.

Uncheck "Protect Structure and Windows"

Review>UnProtect Worksheet

You may need passwords if someone else was playing with your workbook.


Gord Dibben MS Excel MVP
 
Back
Top