S
stew
Hi all
If there is a figure entered in D10
it prompts, in B11 a hyperlink to become active with the the following
=IF(SUM(C10:E10)>0,HYPERLINK("C:\Program Files\Canon\CanoScan Toolbox
Ver4.9\CSTBox.exe","Scan And Name"&" "&ROW()-1&" "&"To Income Receipts")," ")
This opens the scanner and promts the operator to scan the back up paper
work to a file,income receipts. naming it 10
This same format is followed D12 AND B13.
Question. Is there any way of blocking entry into D12 if the prompt in B11
has not been followed?.
i.e.is there an IF formula that would check if a file existed called 10 and
if so unlock D12
Thanks for your time
Stew
If there is a figure entered in D10
it prompts, in B11 a hyperlink to become active with the the following
=IF(SUM(C10:E10)>0,HYPERLINK("C:\Program Files\Canon\CanoScan Toolbox
Ver4.9\CSTBox.exe","Scan And Name"&" "&ROW()-1&" "&"To Income Receipts")," ")
This opens the scanner and promts the operator to scan the back up paper
work to a file,income receipts. naming it 10
This same format is followed D12 AND B13.
Question. Is there any way of blocking entry into D12 if the prompt in B11
has not been followed?.
i.e.is there an IF formula that would check if a file existed called 10 and
if so unlock D12
Thanks for your time
Stew