Excel pops up "The cell or chart you are trying to change is protected and therefore read-only." To modify a protected cell or chart, use the Undo Sheet Protection Command (in the Change group on the Review tab) to unprotect it. You may be prompted to enter a password. window, as shown in Figure 1.
What should be done if this happens? After research, we found two methods to break the protection Code of Excel worksheet.
One, VBA macro code crack method:
Step one: Open the file, and first remove the default macro disabled state by tapping the options Status button under the toolbar, opening the Microsoft Office Security Options window, selecting "Enable this content" and "OK" exit (Figure 2);
Then switch to the "View" tab, click "Macros" → "Record Macro", the "Record New Macro" window, in the "macro name" to define a name: Passwordbreaker (Figure 3), click "OK" exit;