This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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?
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Could you share us the file to check on it？You can share it via private message by click the icon below:
ultimately i recreated the file.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
Now that i have recreated the file, and it worked for a week or so. Some of the cells on one of the tabs are locked and that tab has been protected. I know i didn't do it. And now this work book is junk again.
Any ideas whats causing this? Is it possible to "accidentally" lock it with keyboard strokes, or a macro, that I'm doing inadvertently?
Macro can protect your workbook. You can create a new workbook to check if there is any macro there.
If not, it can be only manual protected.