Prev: Drag and drop data only??
Next: Denormalized data in Excel
From: r25ramirez on 22 Dec 2009 12:04
My company recently upgraded to 2007. I had a file that was protected and
only certain cells could be modified, for data entry. I now need to
manipulate the file but I am unable to unprotect the file. The “unprotect
sheet” button is not available. How do I unlock the protection?
From: Ms-Exl-Learner on 22 Dec 2009 12:09
Press Alt+T+P+P.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"r25ramirez" wrote:

> My company recently upgraded to 2007. I had a file that was protected and
> only certain cells could be modified, for data entry. I now need to
> manipulate the file but I am unable to unprotect the file. The “unprotect
> sheet” button is not available. How do I unlock the protection?
From: Jim Thomlinson on 22 Dec 2009 12:14
If the file is shared you need to unshare it first as that option is not
available in shared workbooks...
--
HTH...

Jim Thomlinson


"r25ramirez" wrote:

> My company recently upgraded to 2007. I had a file that was protected and
> only certain cells could be modified, for data entry. I now need to
> manipulate the file but I am unable to unprotect the file. The “unprotect
> sheet” button is not available. How do I unlock the protection?
From: r25ramirez on 22 Dec 2009 12:19
Nope. nothing happend. A window popped up at the top of the screen looking
like it was accepting the code, but nothing happend. Thanks for the help
though.


"Ms-Exl-Learner" wrote:

> Press Alt+T+P+P.
>
> Remember to Click Yes, if this post helps!
>
> --------------------
> (Ms-Exl-Learner)
> --------------------
>
>
> "r25ramirez" wrote:
>
> > My company recently upgraded to 2007. I had a file that was protected and
> > only certain cells could be modified, for data entry. I now need to
> > manipulate the file but I am unable to unprotect the file. The “unprotect
> > sheet” button is not available. How do I unlock the protection?
From: r25ramirez on 22 Dec 2009 12:26
That's what it was! thank you so much! I was freaking out thinking I had to
create this file over again from scratch! Thanks again!


"Jim Thomlinson" wrote:

> If the file is shared you need to unshare it first as that option is not
> available in shared workbooks...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "r25ramirez" wrote:
>
> > My company recently upgraded to 2007. I had a file that was protected and
> > only certain cells could be modified, for data entry. I now need to
> > manipulate the file but I am unable to unprotect the file. The “unprotect
> > sheet” button is not available. How do I unlock the protection?
 | 
Pages: 1
Prev: Drag and drop data only??
Next: Denormalized data in Excel