I came up with a really short macro for a reader and it works fine. When he moved it to his personal macro file, it stopped working. It throws an error. It's an open event and I'm guessing that's the problem. Can anyone tell me if you can run an open worksheet procedure from the personal macro module? Susan H.