Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Terry Swift
 
Posts: n/a
Default How do I unlock a protected worksheet

I have a password protected worksheet that nobody seems to know the password
to. How can i get around the password protection to change the cell
structures such as fonts, etc.?

Terry
  #2   Report Post  
Michael
 
Posts: n/a
Default

Hi Terry
Have a look here for bypassing passwords.


http://www.mcgimpsey.com/excel/removepwords.html
and here
http://j-walk.com/ss/excel/links/pword.htm

Keep in mind though that the previous user put a password on there for a
reason. Make a copy of your sheet before you make any changes

HTH
Michael Mitchelson


"Terry Swift" wrote:

I have a password protected worksheet that nobody seems to know the password
to. How can i get around the password protection to change the cell
structures such as fonts, etc.?

Terry

  #3   Report Post  
Terry Swift
 
Posts: n/a
Default

Michael,

Thanks for the info. This is for a potential client of mine who got the
spreadsheet from a company they do business with. The company says they
didn't password protect the file, but it asks for one and you can't change
any of the fonts, font sizes, or cell structures without it.

I told my client to be to copy and paste first. We'll see how that works.

"Michael" wrote:

Hi Terry
Have a look here for bypassing passwords.


http://www.mcgimpsey.com/excel/removepwords.html
and here
http://j-walk.com/ss/excel/links/pword.htm

Keep in mind though that the previous user put a password on there for a
reason. Make a copy of your sheet before you make any changes

HTH
Michael Mitchelson


"Terry Swift" wrote:

I have a password protected worksheet that nobody seems to know the password
to. How can i get around the password protection to change the cell
structures such as fonts, etc.?

Terry

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Expand/Collapse Grouped Data in Protected Worksheet Robert Slattery Excel Discussion (Misc queries) 8 November 24th 15 05:08 PM
sorting data on protected worksheet Sue Excel Discussion (Misc queries) 20 November 7th 06 07:31 PM
Sorting on a protected worksheet Sue Excel Discussion (Misc queries) 6 June 12th 05 09:26 AM
Import/Export XML in protected worksheet jgentillet Excel Discussion (Misc queries) 0 May 13th 05 05:42 PM
How use group and ungroup functions while worksheet is protected Gabriel De la Garza Excel Worksheet Functions 1 November 17th 04 01:44 AM


All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"