Good morning johnmac
...and welcome to the forum!!
Sounds to me like the spreadsheet is protected.
Go to Tools > Protection. The first option will be Protect (or maybe unprotect) worksheet, the third will be protect (or maybe unprotect) workbook. If either of these options is "Unprotect" then select it and hope it doesn't ask for a password ...
HTH
DominicB
Bookmarks