Solved

Excel - Worksheet uncontrolled re-lock

Posted on 2011-09-16
12
277 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:Tosagua
  • 4
  • 3
  • 3
12 Comments
 
LVL 12

Expert Comment

by:viralypatel
ID: 36550673
Check the attached version. The issue is resolved in this copy.
CANNON---MANUAL-BILL-OF-LADING--.xls
0
 

Author Comment

by:Tosagua
ID: 36550690
viralypatel,

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

Tosagua
0
 
LVL 12

Expert Comment

by:viralypatel
ID: 36550712
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
 

Author Comment

by:Tosagua
ID: 36550756
viralypatel,

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

Tosagua
0
 
LVL 12

Expert Comment

by:viralypatel
ID: 36550792
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:Tosagua
ID: 36550917
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
 
LVL 12

Accepted Solution

by:
kgerb earned 500 total points
ID: 36569975
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
 
LVL 12

Expert Comment

by:kgerb
ID: 36569986
P.S.  You can also delete Sheet1 now.
0
 

Author Closing Comment

by:Tosagua
ID: 36593031
Kyle,

It works perfectly.

Thank you,

Tosagua
0
 
LVL 12

Expert Comment

by:kgerb
ID: 36594121
You're welcome.  Thanks for the points and the grade:)

Kyle
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now