How Do I Remove a Password from a Workbook in Excel 2010?
How Do I Remove a Password from a Workbook in Excel 2010?
Last edited by Ian Day; 11-09-2010 at 10:42 AM.
Do you know the password?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Yes, I know the password.
Assuming it's similar to 2007, and you're talking about a password to open workbook (yes?) as opposed to worksheet protection;
Open the workbook and use Save As
In the lower right of the file window will be "Tools"
Choose "General Options"
Clear the password.
Save over your old file.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hello and welcome to the forum,
Unfortunately, your post violates rule #11 of the forum rules:
"Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords."
Thank you for your understanding.
Good luck.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Sorry Abousetta, and please do not think this rude or argumentative.
I dont see this as breaking or bypassing a security measure. The poster knows the password, he is just asking how to stop excel asking for it all the time as turning off a workbook password is not as simple as "unticking" the option.
I found this post very helpful as i had the same issue. I created a workbook, password protected the workbook, then later on wanted to remove that password and despite clicking the box saying unprotect workbook and saving the file, it would ask me every time i tried to open it.
Only after i read this post was I able to permanently remove the workbook password using the tips above.
Intended in good faith
Darren
Handy things to keep in mind:
Click *, if my suggestion has helped you
If your problem is solved, then please mark the thread as SOLVED
Sharing is Caring .... spread the knowledge
Hi Darren,
There's obviously a post missing between #5, where Andy Pope provides a link to the MS website and my post. Note that the original thread was started in 2010 and I posted in 2013. Therefore someone must have asked a question on how to break Excel's security in 2013 >> I then responded with my post >> one of the admin or moderators removed the offending post but left mine. Therefore it looks like I am responding to the OP (but three years later)... doesn't really make sense that I would do that. I don't have that much free time on my hands
abousetta
That was my impression too (either that, or I want some of what abousetta has been smoking lol - just kidding, I quit smoking 8 months ago)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Abousetta is right. 2 posts from this thread have been deleted as per the thread history.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Since the thread is presently useless, unworthy of the forum, here is the answer I found. It applies to Excel 2010 for sure.
http://www.howstuffworks.com/how-to-...0-workbook.htm
Last edited by brynbaker; 07-22-2013 at 05:47 AM. Reason: misunderstanding URL tab
Now if you actually read the post, you could have seen that was:
A: not the question
B: not allowed to be discussed according to forum rule #11 as mentioned by Abousetta
Next time please be more careful about what you post and read the questions and answers posed before you reply.
Kind regards,
Michael Star
Wow, Excel really likes to make this sort of thing cryptic, don't they?
In Excel 2010... File > Save As > Tools (it's on the bottom near the Save Button) > General Options. Clear both password fields & uncheck "Read-Only recommended (optional, but suggested). Then either save as a new file or save over your old file.
I think this thread has had enough attention from members posting links on how to remove passwords - which is against the rules on this forum. I am closing this thread now
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks