Unprotect workbook accidentally?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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
 
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!
 
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).
 
jped said:
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,
Click to expand...

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
 
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!
 
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!
 
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!
Click to expand...
 
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!

Gord Dibben said:
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!
Click to expand...
Click to expand...
 
Do not know how protection was removed without a password.

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


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

Gord Dibben said:
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!
Click to expand...
Click to expand...
 
Back
Top