Excel - Worksheet uncontrolled re-lock

We have an Excel based form (Excel 2007) that has been working well, until this afternoon.

Now the Option Buttons are always protected (read only) despite the worksheet being unprotected.

When the worksheet is unprotected, if you click on an Option Button, the worksheet automatically locks by itself, without a password being entered. I belive that is resulting from the last command in the Option Button macro.

To unlock the worksheet again, you need to use the password.

The worksheet is attached. the password is set to: 123

Any insight or suggestions would be appreciated.

Tosagua CANNON---MANUAL-BILL-OF-LADING--.xls
TosaguaAsked:
Who is Participating?
 
kgerbConnect With a Mentor Chief EngineerCommented:
Tosagua,
Please try the attached workbook.  I changed the option buttons from Form controls to ActiveX controls.  That way you don't have to un-protect and protect the worksheet every time the macro runs.

Kyle
Q-27312490-RevA.xlsm
0
 
viralypatelCommented:
Check the attached version. The issue is resolved in this copy.
CANNON---MANUAL-BILL-OF-LADING--.xls
0
 
TosaguaAuthor Commented:
viralypatel,

Are you saying that when YOU click on the the Options Buttons everything is working well ?

Tosagua
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
viralypatelCommented:
yes ... in the file I've attached. Check and let me know if u see the error in the one I've attached too.
0
 
TosaguaAuthor Commented:
viralypatel,

Yes, on our computers, the problem is still there.

Tosagua
0
 
viralypatelCommented:
i just tried "save as" and saved the file with the same name at a different location and it stopped showing the error. Can you check after doing that?
0
 
TosaguaAuthor Commented:
viralypatel,

We just tried it on two different computers, saving it to two different servers.
The problem is still there. So, I don't think that the problem is with the file.

Tosagua
0
 
kgerbChief EngineerCommented:
P.S.  You can also delete Sheet1 now.
0
 
TosaguaAuthor Commented:
Kyle,

It works perfectly.

Thank you,

Tosagua
0
 
kgerbChief EngineerCommented:
You're welcome.  Thanks for the points and the grade:)

Kyle
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.