@ameynevrekar
Hi! This is vba code. It needs to be copied and pasted into Excel vba and run it from there. My recommendation is to save a backup copy of your workbook with a new name for safety. Turn off auto recalculation. Then:
1. Create a new blank worksheet. Your wiil be copying data from your protected to the new worksheet.
2. Use the process I described to copy all of the columns with data in your protected worksheet. For example if your data starts in column A, click on column A to highlight the entire column. Don't release the mouse button yet
3. Move the mouse to the right, selecting additional columns until you have selected all columns with data in your worksheet. Right click and copy the columns.
4. Select the new worksheet you created. Select the first column you copied in your protected worksheet (in the example above it was column A)
5. Paste the data into that column. You now have an unprotected copy of your protected worksheet with all of your data.
6. Rename your protected worksheet to something else. Then rename the new worksheet to the same name that your old protected worksheet was named.
7. Delete the old protected worksheet
8. Turn on auto recalculation
If something gets messed up you still have a backup of your original workbook with the protected worksheet if needed.
Good luck!
