I have several workbooks which I have to password protect for both read and
modify. I have prepared another Excel workbook say Book1 containing both
these passwords (random generated through a program) for each workbook. I
dont want to manually type the long string of text into 'open' and 'modify'
box, that too twice . So I am trying to copy and paste the values from Book1
into these boxes but cant seem to do it now. The funny thing is that I was
able to do it for a couple of files but now it is not allowing me even to go
to Book1 to copy the text. Any ideas?