On Nov 20, 8:56 pm, Teri wrote:
Does anyone know how I can unprotect a protected worksheet received from a
third party. I have been given the password to unprotect the worksheet and
am trying to "Save As" a new file so that I can use the existing formatting
to create a new spreadsheet.

However, when I try to open the newly created/saved workbook I am prompted
for the password again.

Thanks very much.

Take a look at:
http://www.straxx.com/excel/password.html

Per Erik