Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook protected itself?? 2007
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook protected itself?? 2007
Sounds like you have both workbook and worksheet protected.
On Ribbon go to ReviewProtect Workbook. Uncheck "Protect Structure and Windows" ReviewUnProtect Worksheet You may need passwords if someone else was playing with your workbook. Gord Dibben MS Excel MVP On Wed, 4 Nov 2009 06:06:06 -0800, terryc wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unprotect (in Excel 2007) workbook created and protected in Excel | New Users to Excel | |||
Excel 2007 - Encrypted and password protected Workbook | New Users to Excel | |||
password protected workbook | Excel Worksheet Functions | |||
Protected Workbook | Excel Discussion (Misc queries) | |||
Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) |