Re Post

[stew]

I posted this the other day but got no replies. Can any one give me any
information


Thanks 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

 

[FinRazel]

I don't know exactly how you should approach this, but I would suggest
recording a macro that opens file 10, and if it exists, closes it. If file
10 hasen't been created, then the open file line will cause an error. Then,
edit the macro to include an error handling routine, like OnError GoTo, which
could lead to a message box (MsgBox) warning the user to complete B11.

I don't know enough about locking and unlocking cells, or data validation,
to tie the results of the macro to D12, but I hope this helps, anyway.

Another, perhaps easier, approach to take would be to generate some sort of
data, like a serial number, in file 10, and require that number to be entered
somewhere in column D in your main spreadsheet.

Cheers,

 

[stew]

Dear Anne

Food For Thought

I will wait to see if somebody picks up on your good suggestions

Thank you

Stew