ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protection function is not available (https://www.excelbanter.com/excel-discussion-misc-queries/40735-protection-function-not-available.html)

Colin2u

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.

Dave Peterson

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


All times are GMT +1. The time now is 11:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com