 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006Checkbox Problem on Locked Worksheet
Hello all, I am having a problem on a worksheet I created to track employee time. The problem is with the checkboxes. The employee can check the boxes, and you will see the days field at the bottom automatically update. With the sheet protected, the checkboxes go crazy. If you play with them and try to click them, you will see that if you click one, it may check the one next to it, etc. Any help would be greatly appreciated. Here is the link to the file: http://koget.madfrags.com/timesheet.xls The password to unprotect the file is 'test'. Hi I was unable to replicate this problem on the file you referred to. However it sounds like a macro problem. Do you perhaps have another workbook open in the background which could be causing this problem? Glenton Leviqqio Consulting www.leviqqio.com glenton@leviqqio.com > Hello all, > [quoted text clipped - 9 lines] > > The password to unprotect the file is 'test'. Hmm, very strange. I've tried it on multiple computers with the same problem. Did you try clicking on several of the boxes? It happens to me everytime. Some boxes have no problem, while others do. I have turned macro security off, and still the same thing! Thank you very much for your help thus far. Barret There's no macros in timesheet.xls that would cause this problem. The warning comes up because of the form, but the form doesn't have any macros in it either. Do you have any macros in your personals.xls? > Hmm, very strange. I've tried it on multiple computers with the same > problem. Did you try clicking on several of the boxes? It happens to [quoted text clipped - 3 lines] > > Barret I have verified your results -- not only on the locked spreadsheet but also on the unlocked sheet. Depending on how you place the cursor you can click on one cell yet have the effect occur in a different box. As to why it is happening....that I can not help with > Hello all, > [quoted text clipped - 9 lines] > > The password to unprotect the file is 'test'. Thanks for all the help you guys. I just worked around it and had to make the rows taller :) Kind of a hack, but nothing else I can do right now. Thanks again, Barret
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.