Aug 06 2021 06:13 AM
I have a Workbook with a few worksheets with some macro's. The macro's / VBA are protected with a password.
The worksheets are also protected with a password. Some cells in the worksheets can be used to enter data and some cells are locked, mostly because they contain hidden formulas.
Somehow a user has managed to enter data in a protected cell. The formula is gone and overwritten by the entered data.
In my opinion that is only possible bij hacking the worksheet and remove the password.
Or is there another way to do that?
It is Excel 2016 and Windows 10.
Aug 06 2021 10:38 AM
Aug 06 2021 10:54 AM
I have tried to copy text from another sheet to paste it in the protected cell on the protected sheet. But that is not possible. The message appears that it is a protected sheet. So, no pasting possible. At least, not in Windows 10 / Excel 2016.
So I thought maybe if you open the workbook with OpenOffice. Maybe then it is possible to paste something?
I have tried to copy and paste it in Excel for Mac, but that is also not possible.
To unprotect the sheet you need the password.
The only thing to edit the protected cell is by unprotecting with the password (and as I mentioned earlier I am sure the don't have it) or by removing the password with a hacking-program (or something like that).
So, what am I missing here?
Aug 09 2021 01:27 AM
Aug 09 2021 05:11 AM
Aug 09 2021 06:39 AM
@gandalf1960 It says more about the compatibility of Google sheets when reading Excel files to be honest. Apparently it does not respect the protection setting.
FYI: Sheet protection is quite poor in Excel. A good reason to separate your input and calculations!
Aug 10 2021 02:27 PM
Aug 11 2021 01:08 AM
Aug 13 2021 05:27 AM