On Mon, 29 Dec 2008 11:56:46 -0800 (PST), Ed from AZ wrote:

¤ I have an XL 2007 workbook on a server. The workbook must be accessed
¤ by multiple users with full write/modify permissions. So far, not a
¤ problem - until more than one person tries to access the workbook at
¤ the same time! The workbook is saved as a Shared File, and there are
¤ no protections.
¤
¤ The set-up of the workbook was intended to be as painless for the user
¤ as possible - there is a "form" created from cells (not a User Form)
¤ on one page. Most of the time, all they need to do is enter data into
¤ the "form" and hit the button to run a macro that enters their data.
¤ Occasionally, though, someone needs to create a new worksheet. I
¤ tried doing that with a macro also, so the users would not have to
¤ worry about correctly creating the new sheet so the data entry macro
¤ would see it and properly enter the data, but Excel woulid not allow
¤ those modifications.
¤
¤ I had thought about creating a VB6 (Classic) wrapper" for the
¤ workbook, and put all the functions in the VB program, vice macros in
¤ Excel. Would that alow greater flexibility for the multiple users?
¤ Or is there a simple way to get XL 2007 to allow modifications by
¤ multiple users across a server?

Did you set the Share Workbook Editing option to allow changes by more than one user at a time?

The following may help troubleshoot the issue as well:

http://support.microsoft.com/kb/271513


Paul
~~~~
Microsoft MVP (Visual Basic)