Locking (Protecting) Forms and Controls

  • Thread starter Thread starter Justin
  • Start date Start date
J

Justin

Quick question. I appreaciate any response. I have implemented
checkboxes within an excel file. These checkboxes have no funciton
except visually. I have tried everything I can find but cannot protect
their STATE ie(checked, unchecked) I want to be able to distribute
this file without allowing users to change the state of the checkboxes.
I simply cannot find anything on this. Is it possible? if anybody
knows please postback thanks.
 
Quick question. I appreaciate any response. I have implemented
checkboxes within an excel file. These checkboxes have no funciton
except visually. I have tried everything I can find but cannot protect
their STATE ie(checked, unchecked) I want to be able to distribute
this file without allowing users to change the state of the checkboxes.
I simply cannot find anything on this. Is it possible? if anybody
knows please postback thanks.
Click to expand...

Properties-->Enabled=False
 
Justin,

SOme possibilities. If you'll be protecting the sheet, then set up a linked
cell to a cell that is locked. This applies to either Forms Toolbar check
boxes, or Controls Toolbox ones.

If you won't be protecting the sheet, you can take a picture of a checkbox
(with it selected, and in the state you want, checked or unchecked) by
holding Shift, Edit, Copy picture. Now paste to the desired location. Seems
to work better with check boxes from the controls toolbar. Users will still
be able to select and move them around, though.
 
Back
Top