Hello

What I am looking to do is give the end-user an option to open a file by typing in the file name in a specific cell (say b10:) My end-users deal with creating and referencing contracts. So, if they need to open a contract, all they would have to do is type in the contract # (which is the file name) and have it opened. Is this possible to do with a user-form or somehow create a macro from this. All the contracts are located on a share drive, but they are saved in different folders. Is it possible to have the macro search all folders for this file or would they all have to be under one folder?