Blocking Cells if instruction not followed

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top