View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bala_psgtech bala_psgtech is offline
external usenet poster
 
Posts: 1
Default Getting Excel password using vba


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
bal

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