Personally, I like to use only one instance of excel--it makes sharing stuff
between workbooks much easier.

But look under Window, you'll see all the windows (with the workbook name) that
are open in that instance.

neeraj wrote:
>
> Thats what it was ! Even if there are 2 instances of excel running and one
> has several Excel windows open, they seem to get piled up on top of one
> another. How can one find which window belongs to which session
>
> "Dave Peterson" wrote:
>
> > Are you trying to copy the passwords when that password dialog is open?
> >
> > If yes, then excel won't even let you select your cell while that dialog is
> > waiting for your input.
> >
> > I'm gonna guess that the time you actually did it, you had two instances of
> > excel running. And you were actually swapping applications (the two
> > applications just happened to be excel, though).
> >
> > I think I'd use a intermediate helper application.
> > I'd open the workbook that contains the passwords.
> > then windows start button|run|Notepad|and hit enter.
> > then copy the names and passwords from excel into notepad.
> >
> > You could even close that password workbook if you want. And close Notepad
> > without saving when you're done. (Or just move all the passwords into a plain
> > text file and open it when necessary.)
> >
> > neeraj wrote:
> > >
> > > 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?
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson