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?

Ed