www.Excelolozy.com - Copying data from a password protected file with locked seletion is not easy.
Here is a trick through which any cell can be clicked or selected from protected sheet.
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
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