Hi all,

I have 2 workbooks, in the first one I have a macro that opens the
second workbook (at current the sheets are password protected for
security reasons). I want to be able to pass a variable from the first
workbook to the second so that I am able to unprotect the second
workbook automatically.

Note: The second workbook should always remain protected unless it has
been opened using the macro from the first workbook.

TIA


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=535537