The password is set when the xls file is saved. They went in to General options when they were savign the file and set a password upon open in the options. So if you were opening it normally it prompts you to type in the password or open it as read only.

The cells will not change all I'm updating is two cells and only two cells.
cells like E7 and E8 I figured out how to change it on my onw.

Basicly this spread sheet is to track a systems up time. So each day we have to go into the spread sheet and mark if the system is up or down and leave initials. We do this each day and each month. I was able to igure out how to update the cells each day by using some of the Day and Day of Month veriables. Each of the worksheets is a month and year like AUG-07. I've got that down as well. I just need to get a second cell and the password thing taken care of.