Simple excel sheet protected itself?

Question

I have a simple excel sheet that I keep track of my hours for different projects, etc. I think ever since I tried adding a macro to clear certain cells, and another macro to insert a row, appears to be when the problem started? The macros are very simple, although I never got them to work successfully. I searched all macros for the entire workbook for ".protect", but found nothing. Any ideas? I don't share it with anyone else. and i tried unprotecting it by hitting enter with no password, that didn't work either. So if it protected the worksheet somehow, is there a default password it would have assigned?

Answer 1

Could you share us the file to check on it？You can share it via private message by click the icon below:

Answer 2

I just noticed this on the bottom left of the workbook? Could this have something to do with my issue?

Answer 3

Hi bobhamblin,

Greetings! Thank you for posting to Microsoft Community.

Do you mean your workbook is suddenly protected by itself? Could you copy your content to new workbook?

There is no way to unprotect one workbook without password.

Best Regards,

Snow Lu

Answer 4

Share some screenshot of your issue may help to check it.

Answer 5

Yes, the program seems to have locked itself. I don't share the document with anyone, I know I didn't set a password. However, I do have a macro as shown above in the screenshot. Also I can't seem to copy the worksheet to paste it elsewhere as it is protected. Any thoughts?