ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to protect without getting the warnings (https://www.excelbanter.com/excel-worksheet-functions/56548-how-protect-without-getting-warnings.html)

Conditional Formatting

how to protect without getting the warnings
 
we are creating some XLS forms (for people to fill-in) with simple check
boxes etc...
Do you have expertise in this : I need these forms to be totally protected
(cells should not even be selectable) except very few ones where TEXT should
be typed and the radio buttons and check boxes.
when using the standard sheet protection from +XLS, I get all kind of
warning when using the check boxes etc...
do you know how to protect without getting the warnings?

we want the GREY area to remain fillable only (plus the check boxes and
radio button). Currently these two type of cells are set on "unlocked" the
rest being 'locked'

Many thanks


All times are GMT +1. The time now is 04:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com