 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008Unprotecting 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. Check out this link... http://www.mcgimpsey.com/excel/fileandvbapwords.html  SignatureHTH... Jim Thomlinson > 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. So, in other words, I can't do it myself? > Check out this link... > [quoted text clipped - 3 lines] > > 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. 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 >So, in other words, I can't do it myself? > [quoted text clipped - 5 lines] >> > 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. 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 > So, in other words, I can't do it myself? 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! > Following on from Gord's post, be sure to read the Disclaimer, in > particular: [quoted text clipped - 9 lines] > > > So, in other words, I can't do it myself? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.