anything in Excel...

It's Excel-o-lozy...

Selecting data from Locked or Password protected Excel Sheet.

www.Excelolozy.com - Copying data from a password protected file with locked seletion is not easy.

BUT rather not impossible.

Clicking on a locked or password protected sheet doesnt work i.e. any cell can't be selected so it can't be copied.

Here is a trick through which any cell can be clicked or selected from protected sheet.
 

Open "TabManager" (click here to get "TabManager").

Select the sheet which is to be unlocked.

Go to option "Apply"...

Click on "No Click" to Tick it (i.e. selected sheet will be Locked)

and again Click on it to Untick (i.e. selected Sheet will be UnLocked)

Cool trick??? ... moreover password remains same as it is.


Anything in Excel, be an Excelolozian...

for best MS Excel Tips visit http://www.Excelolozy.com

gotta query??? drop a mail at mail@excelolozy.com