I would like to be able to have the macro code "check" the box in VBA Tools>References so that the user does not have to do this. This would make the macro more portable. This would come in handy for both VLOOKUP and SOLVER macros. Any suggestions?