I'm confused. I thought you wrote that the problem was that when a second
Excel instance opened you were prompted "Personal.xls is already open, do
you want to open it read-only?".

If so, then my code would go in your Personal.xls, and you would add a call
to it in your Sub Auto_Open or WorksbooksOpen event in Personal. When
Personal opens it will run this code, making itself RO. Since it's RO a
second instance of Excel will not prompt you that Personal is already open.

--
Jim Rech
Excel MVP
"Greg B" wrote in message
...
| Hi Jim thanks for the answer, The trouble I have is I made a file called
| "backup' and I get windows to open this every hour. So where would I put
| this code as such? Do I put it with the macro that runs with "backup"
|
| Thanks
|
| Greg
|
|