Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protection function is not available
I really do need some help. I finished creating a Family budget plan on one
one entire sheet and at the end of it all I protected the worksheet and workbook after completion. then and only then, I realized that there are areas that i have that is protected that is NOT to be protected. Know when I try to go in and unprotect the sheet/book it will not allow me to do so. the option to unprotect is grayed out preventing me from unprotecting me worksheet/book. if it helps, i am using office XP. |
#2
|
|||
|
|||
Did you share the workbook?
Do you have multiple worksheets grouped? Look in the title bar. If you see [Shared] or [Group] in that title bar, then you'll have to unshare it or ungroup the sheets first. Colin2u wrote: I really do need some help. I finished creating a Family budget plan on one one entire sheet and at the end of it all I protected the worksheet and workbook after completion. then and only then, I realized that there are areas that i have that is protected that is NOT to be protected. Know when I try to go in and unprotect the sheet/book it will not allow me to do so. the option to unprotect is grayed out preventing me from unprotecting me worksheet/book. if it helps, i am using office XP. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |