ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Unprotecting an Excel Spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/185671-unprotecting-excel-spreadsheet.html)

Annie

Unprotecting an Excel Spreadsheet
 
How do I unprotect an Excel sheet without knowing the password? Or, how do I
copy the information into another sheet and make it unprotected? My company
just updated to Office 2007; I'm still getting used to the change.

Jim Thomlinson

Unprotecting an Excel Spreadsheet
 
Check out this link...

http://www.mcgimpsey.com/excel/fileandvbapwords.html
--
HTH...

Jim Thomlinson


"Annie" wrote:

How do I unprotect an Excel sheet without knowing the password? Or, how do I
copy the information into another sheet and make it unprotected? My company
just updated to Office 2007; I'm still getting used to the change.


Annie

Unprotecting an Excel Spreadsheet
 
So, in other words, I can't do it myself?

"Jim Thomlinson" wrote:

Check out this link...

http://www.mcgimpsey.com/excel/fileandvbapwords.html
--
HTH...

Jim Thomlinson


"Annie" wrote:

How do I unprotect an Excel sheet without knowing the password? Or, how do I
copy the information into another sheet and make it unprotected? My company
just updated to Office 2007; I'm still getting used to the change.


Gord Dibben

Unprotecting an Excel Spreadsheet
 
That depends upon your interpretation of the words "spreadsheet" and "sheet".

Generally the word spreadsheet is used to indicate an Excel workbook with one or
more worksheets contained therein.

Do you have a workbook you can open but a worksheet you cannot unprotect?

That is much simpler......see John's other site for breaking internal passwords.

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


Gord Dibben MS Excel MVP

On Wed, 30 Apr 2008 09:14:01 -0700, Annie
wrote:

So, in other words, I can't do it myself?

"Jim Thomlinson" wrote:

Check out this link...

http://www.mcgimpsey.com/excel/fileandvbapwords.html
--
HTH...

Jim Thomlinson


"Annie" wrote:

How do I unprotect an Excel sheet without knowing the password? Or, how do I
copy the information into another sheet and make it unprotected? My company
just updated to Office 2007; I'm still getting used to the change.



Pete_UK

Unprotecting an Excel Spreadsheet
 
Following on from Gord's post, be sure to read the Disclaimer, in
particular:

" ...
so, if in doubt, ask the original author, and if you can't ask - don't
use it!
..."

Would YOU like someone stealing from you?

Pete


On Apr 30, 5:14*pm, Annie wrote:
So, in other words, I can't do it myself?


Annie

Unprotecting an Excel Spreadsheet
 
The person who protected the SHEET was in the job position that I'm in now.
They didn't leave me the password. I'm not stealing anything. Anyway, my IT
guy unprotected it for me. I don't know how, but it only took about 2
minutes.

Thanks for the help everyone!

"Pete_UK" wrote:

Following on from Gord's post, be sure to read the Disclaimer, in
particular:

" ...
so, if in doubt, ask the original author, and if you can't ask - don't
use it!
..."

Would YOU like someone stealing from you?

Pete


On Apr 30, 5:14 pm, Annie wrote:
So, in other words, I can't do it myself?




All times are GMT +1. The time now is 04:01 PM.

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