VB Passwords

[booth942]

I have created several excel workbooks which contain various macros
and vb code that requires worksheets and/or workbooks to be unlocked -
these all work ok - the problem is now i want to combine all the
different workbooks and therefore i need to change the some of the
passwords.

how do i do this?

 

[Bob Phillips]

Go into the VBIDE (Alt-F11), and from there menu option Tools>Properties and
navigate to the Protection tab.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)