Excel Form & Protection Help - Geeks to Go Forums

Jump to content

Log in Register Register Malware removal guide How it works

Excel Form & Protection Help

#1 SadiesMom

  • Group: Member
  • Posts: 8
  • Joined: 22-February 09

Posted 17 January 2012 - 08:44 PM

In an Excel file, I have two radio buttons in a group. I need for people to click one or the other. However, I need to protect the whole worksheet. When I protect the worksheet the radio buttons cannot be clicked. I have unprotected them, but they still won't allow the user to click them.
How can I protect the worksheet, but allow for the radio buttons to be clicked?

Thanking you in advance.

#2 Jonesey

  • Group: Member
  • Posts: 335
  • Joined: 21-September 05

Posted 23 January 2012 - 09:14 AM

Are you still in Design Mode by any chance? That will produce what you're seeing

#3 SadiesMom

  • Group: Member
  • Posts: 8
  • Joined: 22-February 09

Posted 25 January 2012 - 09:04 PM

Hello Jonesey,
Nope, not is design mode. And all cell attributes are unlocked. Yet everytime I try to protect the worksheet the radio button are not accessible. I'm just not understanding what I'm doing wrong : (

Share this topic: