Password

Smoakstack

Board Regular
Joined
Mar 28, 2011
Messages
79
I am having some password protection problems. Here is the dilemna, I open Excel and it asks for a password. I have it, but I do not want it to ask for one. I have used numerous password clear things, but none have done the trick. Now I can only access the read only. Any Suggestions? Let me know if you need any of the code or anything else
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

MrKowz

Well-known Member
Joined
Jun 30, 2008
Messages
6,653
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
You need to enter the password to open it normally, then use Save As and before you click Save, click on "Tools" in the Save As dialogue box and choose General Options. Remove the password protection there.

If none of your passwords work to open the file, then we cannot be of assistance, as that would breach forum rules See Rule #20
 

Smoakstack

Board Regular
Joined
Mar 28, 2011
Messages
79
Oh yeah, I do have access to an earlier version of the file, but do not know what is going on with the code and why it locks up on me when I try to access the newer version.
 

MrKowz

Well-known Member
Joined
Jun 30, 2008
Messages
6,653
Office Version
  1. 365
  2. 2016
Platform
  1. Windows

Watch MrExcel Video

Forum statistics

Threads
1,122,186
Messages
5,594,745
Members
413,929
Latest member
Hypatia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top