refer to a cell for password

B

Brian

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?
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Password Protect - put password in a cell in the workbook 2
Macro code mod - add tabs/apply to entire workbook 2
run-time error dialog 1
Put password for excel file in VB code 1
VB password lost 3
Password protect worksheet 1
Enable users to edit charts on a protected worksheet 3
Controlling worksheet protection via VBA 0

Top