Checkbox Problem on Locked Worksheet

B

bjlemaire

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'.
 
G

Guest

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
(e-mail address removed)
 
B

Barret

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
 
G

Guest

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?
 
G

Gail

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
 
B

Barret

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top