Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Colin2u
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I NEED HELP with the SPELLNUMBER Function vag Excel Worksheet Functions 0 June 21st 05 08:17 AM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
Date & Time mully New Users to Excel 4 May 23rd 05 11:56 AM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM


All times are GMT +1. The time now is 11:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"