Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print a worksheet when a cell = 1
I want to print a worksheet when a value of 1 appears in cell A1
(The cell is linked to another program which will write a 1 into the cell when a printout is required) Please tell me how I can achieve this all suggestions welcome |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print a worksheet when a cell = 1
Is that link a formula to a different worksheet in a different workbook?
Or is it the result of some kind of query? A little more information may help get an answer. Pat wrote: I want to print a worksheet when a value of 1 appears in cell A1 (The cell is linked to another program which will write a 1 into the cell when a printout is required) Please tell me how I can achieve this all suggestions welcome -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print a worksheet when a cell = 1
I have a PLC (Programmable logic Controller) writing to the spreadsheet via a
DDE link. (The PLC is controlling a batching plant) The spreadsheet is used to store alarm / recipe information. What I want is a way of printing a report on demand via the PLC hence the idea of writing a 1 in a cell to trigger a print routine. Hope this gives you a better understanding of what I am trying to do. "Dave Peterson" wrote: Is that link a formula to a different worksheet in a different workbook? Or is it the result of some kind of query? A little more information may help get an answer. Pat wrote: I want to print a worksheet when a value of 1 appears in cell A1 (The cell is linked to another program which will write a 1 into the cell when a printout is required) Please tell me how I can achieve this รขฌ all suggestions welcome -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print a worksheet when a cell = 1
I don't know anything about DDE links. Maybe someone else will jump in.
Pat wrote: I have a PLC (Programmable logic Controller) writing to the spreadsheet via a DDE link. (The PLC is controlling a batching plant) The spreadsheet is used to store alarm / recipe information. What I want is a way of printing a report on demand via the PLC hence the idea of writing a 1 in a cell to trigger a print routine. Hope this gives you a better understanding of what I am trying to do. "Dave Peterson" wrote: Is that link a formula to a different worksheet in a different workbook? Or is it the result of some kind of query? A little more information may help get an answer. Pat wrote: I want to print a worksheet when a value of 1 appears in cell A1 (The cell is linked to another program which will write a 1 into the cell when a printout is required) Please tell me how I can achieve this รขฌ all suggestions welcome -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
One spreadsheet cell won't print but shows up in print preview? | Excel Discussion (Misc queries) | |||
Why can't I link a cell from worksheet to another when it has an . | Excel Worksheet Functions | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |