refer to a cell for password   

I have built VB code that refers to a cell on a sheet for the password to 
protect the sheet.

I now need to protect the VB code and would like to use the same cell 
reference for the password - that way the password only needs to be changed 
in one place (rather than using the properties>protection dialog box for the 
VB project).

Is there any way to protect the VB project/code using VB code?

date: Tue, 22 Jul 2008 15:19:04 -0700   author:   Brian

Re: refer to a cell for password   

Excel doesn't share any mechanized way to do this with developers.

The closest thing I've seen is to use Sendkeys to traverse the dialogs.

But I wouldn't rely on that ever.

Brian wrote:
> 
> I have built VB code that refers to a cell on a sheet for the password to
> protect the sheet.
> 
> I now need to protect the VB code and would like to use the same cell
> reference for the password - that way the password only needs to be changed
> in one place (rather than using the properties>protection dialog box for the
> VB project).
> 
> Is there any way to protect the VB project/code using VB code?

-- 

Dave Peterson

date: Tue, 22 Jul 2008 19:43:00 -0500   author:   Dave Peterson