Matt or anyone else that can help,


My workbook has come along nicely and I just recently added a password to modify the sheet. Using the formulas from the previous posts, I created a

1) Save to Local button
- This saves to the computers hard drive in the order of
- D:/Asphalt Core Data/Job Number/ Mix Type/ User.xls

2) Transfer to J Drive
- this saves to the computers network drive
- J:/Asphalt Core Data/Job Number/ Mix Type/ User.xls

Everything worked well until i added the password to modify in the save as general options. I saved a blank and then handed it out to our employees. Now it will ask for the password when you first load it and it will allow you to add data. When I go to save it though, it will give me the 1004 error that the sheet is write reserved. Do I need to put a password prompt in my two macro buttons to prompt for password right before saving to get rid of this error. It is necessary to have it read only on the network drive so that others that have access to it cannot accidentally destroy the data. It is also necessary to be able to modify the data on the network drive so that is why I went the password route. Any help would be appreciated. I am stumped and stuck.

Thanks in advance.