This makes total sense. But how do I go about updating information in a closed password protected workbook. One good thing is my workbooks are password protected with user interface only.