mercredi 25 janvier 2017

Locking Excel Sheets that have ActiveX Checkboxes

I have an excel file that uses multiple ActiveX Checkboxes, of course these all have a linked cell and when clicked pulls data from another sheet to show i figure next to the checkbox.

The file also uses concatenation to provide information once a person has chosen from some data validation drop downs above - The concatenation occurs on the sheets elsewhere so of course many cells change values depending on selection of the drop downs and check boxes.

Is there a way of locking the sheet or workbook that means a person can still choose desired information in the drop downs, for it to concatenate and display information in other cells, and for check boxes to check and show information whilst the user is unable to view and/or select/change any formulas or cells in the sheet?

Hope this is clear, thanks for your help!!




Aucun commentaire:

Enregistrer un commentaire