Unprotect workbook accidentally?

[Guest]

Hi, I have a client who created a workbook with a hidden, password protected
sheet included. She sent it out to a client of hers who then faxed back the
worksheets, including the password protected hidden sheet. This person
somehow unprotected the sheet. She claims this person is a novice user who
hardly knows his way around a computer. Is it possible to somehow
"accidentally" unprotect a workbook? Thanks for your help!

 

[Guest]

Worksheet protection should really only be considered a means to keep people
from accidently changing things. It can easily be removed:

http://www.mcgimpsey.com/excel/removepwords.html

 

[Gord Dibben]

I have read that using Hotmail to send Excel workbooks can remove the sheet
protection.

Could this be the case here?

I can't replicate using Outlook and have no Hotmail account to test.


Gord Dibben MS Excel MVP

 

[Guest]

She is using Outlook as well. I can't replicate it either. I understand
that it's easy to unprotect the worksheet is you're trying to do it. I'm
beginnging to think maybe this user isn't as inexperienced as she thinks...
Thanks for your response and let me know if you think of anything else.
Thanks!

 

[Guest]

FWIW - I tried sending a file through hotmail and it did not remove the sheet
protection. Is your client sure the worksheet protection was removed? Just
because the worksheet was unhidden and faxed back does not mean it's
unprotected. Were changes made? Also protection only applies to cells that
are locked (Format/Cells/Protection - Locked).

 

[Desert Piranha]

Hi, I have a client who created a workbook with a hidden, passwor
protected
sheet included. She sent it out to a client of hers who then faxe
back the
worksheets, including the password protected hidden sheet. Thi
person
somehow unprotected the sheet. She claims this person is a novice use
who
hardly knows his way around a computer. Is it possible to somehow
"accidentally" unprotect a workbook? Thanks for your help!Hi jped,

I may be missing something here but just password protecting
worksheet and hidding it,
does not stop you from going to "Format>Sheet>Unhide" and unhiding it


Unless its "xlSheetVeryHidden" with code.

Am i wrong

 

[Guest]

No changes were made to the hidden sheet. Her main concern was that the
sheet was seen at all. It has some sensitive information they use after the
client fills out the other sheets. How would her client be able to print out
the hidden sheet? I can only get to it if I enter the password to unprotect
it, then unhide it. Format>Sheet>Unhide is grayed out until I enter the
password. Is there a way to view or print out a hidden sheet without
entering the password? Thanks!

 

[Guest]

When I go to Format>Sheet>Unhide without entering the password, this is
grayed out. Once I enter the password, it's active. Is there a way to view
or print the hidden worksheet without entering a password? Thanks!

 

[Gord Dibben]

Format>Sheet>Unhide etc. being grayed out indicates to me that you have the
Workbook Protection enabled, not Worksheet Protection.

Worksheet Protection still allows sheets to be unhidden as Piranha states.

Maybe both are protected.


Gord Dibben MS Excel MVP

When I go to Format>Sheet>Unhide without entering the password, this is
grayed out. Once I enter the password, it's active. Is there a way to view
or print the hidden worksheet without entering a password? Thanks!

 

[Guest]

OK, Workbook Protection is enabled. Once I unprotect the workbook, then I
can unhide and edit the hidden worksheet. Sorry for any confusion. Is there
anyway to get around the workbook protection to view/print the hidden
worksheet without entering a password? Thanks!

Format>Sheet>Unhide etc. being grayed out indicates to me that you have the
Workbook Protection enabled, not Worksheet Protection.

Worksheet Protection still allows sheets to be unhidden as Piranha states.

Maybe both are protected.


Gord Dibben MS Excel MVP

When I go to Format>Sheet>Unhide without entering the password, this is
grayed out. Once I enter the password, it's active. Is there a way to view
or print the hidden worksheet without entering a password? Thanks!

 

[Gord Dibben]

Do not know how protection was removed without a password.

Passwords are easy to crack. Possibly the recipient knows the tricks.


Gord

 

[Guest]

That's what I'm thinking. Thanks for your help, I appreciate it. If you
think of anything else, let me know. Thanks!

Do not know how protection was removed without a password.

Passwords are easy to crack. Possibly the recipient knows the tricks.


Gord

OK, Workbook Protection is enabled. Once I unprotect the workbook, then I
can unhide and edit the hidden worksheet. Sorry for any confusion. Is there
anyway to get around the workbook protection to view/print the hidden
worksheet without entering a password? Thanks!