When you have a Excel file which is protected and you have forgotten the password.
Now how do you retrieve the content from the hidden sheet?
There is a simple technique but the requirement is you should know the sheet name of hidden sheet or you VBA environment should not be password protected.
Lets assume the hidden sheet name is 'Sheet2'. To retrieve only the content from this sheet, all you have to do is write a A1 cell reference formula in a visible sheet like below. Now drag this to right and down as much as needed. Voila! you have the data from hidden sheet in front of you.
If you do not know the sheet name. Then hit Alt+F11, on the top left side you will see all the sheets of the current workbook. Based on your needs you can get the data from a hidden worksheet.
Again, this tip is not intended to be used in illegal ways but only in cases it is desperate need and there is no other option.
Thanks for visiting. If you have any questions reach out to me directly at askme.kkhelps@gmail.com
No comments:
Post a Comment