Well, it happened again!

Tom Ogilvy wrote:

apparently Dave misread the requirement. (although locking (rather than
unlocking) the underlying linked cells is not totally effective from a visual
standpoint)

See my answer in this thread.

--
Regards,
Tom Ogilvy

"Jordan" wrote:

Unfortunatly they want to see all the available checkboxes, they just don't
want anyone to have the ability to click on them.

"Dave Peterson" wrote:

You have to unlock those linked cells.

Maybe you could put them in a column and hide the column--or even put them in a
different worksheet???

Jordan wrote:

Hello,

I have a worksheet that contains a ton of checkboxes created using the Forms
toolbar not the Control Toolbox. I want to protect that worksheet so that
people can't do anything to the worksheet itself, including checking or
unchecking those checkboxes. There is a maco that goes through and
unprotects the worksheet, checks the appropriate boxes and then protects the
workbook again. The problem I have is that when I protect the worksheet I
can stop them from doing anything except checking the boxes. How do I stop
them from being able to check the boxes?

Thanks,
jordan

--

Dave Peterson


--

Dave Peterson