Solved

Excel - Worksheet uncontrolled re-lock

Posted on 2011-09-16
12
282 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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
 

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

749 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