There is no way to retrieve a password with VBA. That would defeat the
purpose of having a password.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"bala_psgtech" wrote in message
...

hi

Can you please help in solving a problem in excel/VBA...

iam having a excel sheet which is protected by a password....

inorder to do some operations through VBA, first i must unportect

the work sheet.....for this i need the password to unprotect the

sheet...currently i have hardcoded it in my code........but when the

user changes the password......wat will be the case....???? again i

should go to the code and change ....

so, do u guys know how to get the password (which is set by the user)
through VBA..

please help me.....

regards
bala


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/