Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock out manual input to cells?
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock out manual input to cells?
Have you trying reading Help on this?
1. You can protect the sheet (or the entire book). Format the cells as Protected, then use Tools Protection. 2. From VBA you can set Interactive = FALSE, which switches off the user interface completely. "Jon" wrote in message oups.com... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock out manual input to cells?
Yep, thats all I needed. I didn't think that would work at first
because the values in the cells are updated by DDE links. But I realized that the actual contents of the cell never change (just the value it produces). Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual Input/Calculation in Same Cell | Excel Discussion (Misc queries) | |||
Cell Reference VS. Manual Input? | Excel Worksheet Functions | |||
lock cells for input | Setting up and Configuration of Excel | |||
Lock and unlock cells conditionally depending on input in another | Excel Worksheet Functions | |||
Manual Input During Macro Execution | Excel Programming |