Reply to thread

Message: [QUOTE="OMER, post: 6434682"] Thank You Peter T for you prompt response. Definetively your code is better developed that mine. However, mine is not sending any error code. If I disable the VBA password protection, it runs smoothly. The issue arises when I enabled the VBA password. The workbook prompts for the VBA password. If I click cancel (to ignore the passowrd message) it continues to run without a problem and correctly sets the Solver reference. I believe it has to do with setting the Solver reference while the password protected, but I want to avoid the password prompting. Any more ideas? Regards, OMER [/QUOTE]