Please Please Please help

[Ann]

Hi
I have a Worksheet with option buttons and I need the
users to be able to click on the options but not be able
to drag or move them. I don't want the users to be able
to click into or type anything in any of the cells - only
these options buttons???? How is it done.
I have tried unlocking all cells and then locking the
individual ones, but the user can still drag the option
button around and they could do this by mistake thus
upsetting the design of my sheet! I have tried protecting
the sheet for Objects - but then I can't click on the
option at all ....Please someone help me before I go mad!!

Thanks

Ann

 

[Bill Lunney]

Try using the ActiveX buttons instead (Control toolbox toolbar instead of
Forms). You need to go into design mode in order to make any changes etc.
Unless your users do this they won't be able move or edit anything.

--

Regards,


Bill Lunney
www.billlunney.com

 

[Lynn Schauer]

if you create the option buttons from the Controls Toolbox, then Exit Design
Mode, they will still work properly, but the user will not be able to move
them unless they know how to reenter Design Mode.

Lynn S