Shared Workbook with 32 sheets only retains frames for first user in file.

[Royzer]

Hi.

We have a shared workbook (version 2003) on a shared drive that sometimes has up to 10 people accessing it at the same time. I have set the frames on all the worksheets to B9 and saved the file. The first person to open the file has frames. Subsequent (simultaneous) users do not have frames. It appears that this occurs every time the file is accessed by multiple users at once--whomever opens the file first gets the frames and no one else does. Is there any way to change this so everyone who is in the file at the same time has frames on the worksheets they are working in? Here is the code I used to set the frames:

Please Login or Register  to view this content.

Thanks!

[Royzer]

Resetting my notification method to instant email, because I don't know how to reset it any other way.

[Royzer]

This has been resolved. This macro runs on wb open and sets all frames at that point. Once the shared workbook is open and the frames set, subsequent users' sheets have frames when they enter the wb.

Please Login or Register  to view this content.

[OnErrorGoto0]

Why not just call freezeframesatB9 from the Open event?

[Royzer]

I guess the main reason is that my vba knowledge level is somewhere between beginner and intermediate, but closer to beginner.

I wish I had found that before I went through adding all those lines. Thank you for the reply. That is something I will use next time!