VB Passwords

  • Thread starter Thread starter booth942
  • Start date Start date
B

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?
 
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)
 
Back
Top