View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike R. Mike R. is offline
external usenet poster
 
Posts: 59
Default Password Protect - put password in a cell in the workbook

Hi - I have some VB code that runs throughout my workbook and it does a lot
of protecting/un protecting of sheets. I have hard-coded the password into
the vb code. I am fearful that if I need to change the password, I will not
change it everywhere. I would like to instead put the password on my data
sheet and then have the vb code refer to cell A1 on sheet1 to get the
password. Is this possible?
Thanks,
Mike