Home |
Search |
Today's Posts |
#1
|
|||
|
|||
group box protection
I have an excel 2000 workbook filled with proprietary formulas, etc that are
hidden in protected cells and sheets of the workbook. One worksheet is protected but has a few cells unlocked for data entry by a user. Part of the data entry is a Group Box with 5 Option Buttons. I have unprotected each option button, the group box and the cells that they are sitting on top of but still cannot enter data when the sheet is protected. |
#2
|
|||
|
|||
Do you have a linked cell for the optionbuttons?
Is that cell locked on that protected sheet? SWEdwards wrote: I have an excel 2000 workbook filled with proprietary formulas, etc that are hidden in protected cells and sheets of the workbook. One worksheet is protected but has a few cells unlocked for data entry by a user. Part of the data entry is a Group Box with 5 Option Buttons. I have unprotected each option button, the group box and the cells that they are sitting on top of but still cannot enter data when the sheet is protected. -- Dave Peterson |
#3
|
|||
|
|||
Dave,
You the man! One simple sentence was all it took. Thanks! Steve "Dave Peterson" wrote: Do you have a linked cell for the optionbuttons? Is that cell locked on that protected sheet? SWEdwards wrote: I have an excel 2000 workbook filled with proprietary formulas, etc that are hidden in protected cells and sheets of the workbook. One worksheet is protected but has a few cells unlocked for data entry by a user. Part of the data entry is a Group Box with 5 Option Buttons. I have unprotected each option button, the group box and the cells that they are sitting on top of but still cannot enter data when the sheet is protected. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet protection and "Group and Outline" | Excel Discussion (Misc queries) | |||
Calculate cell row and column | Excel Discussion (Misc queries) | |||
Need help w/ Weight Formula | Excel Discussion (Misc queries) | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |