I have a spreadsheet that is updated via DDE links. Currently, I have
a computer set up with keyboard and mouse at the piece of equipment
that I am communicating with. My problem is that people can just walk
up to the computer and modify my spreadsheet. The spreadsheet is
always open because it is viewed by operators, but I do not want them
to have the ability to modify the sheet, all modifying is done by the
DDE links. Is there any way to set Excel to prevent input by a user?
I could simply unplug the keyboard but I need to access the PC on
occasion. Any ideas?