Hi, Paul.

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

Yes, I did. The workbook is at work, and I'm still off on vacation
until next week, so I can't check specifics. But I do know I did
that. I just wanted to collect some insight before I go back and
start trying to craft a VB wrapper or dig into the workbook settings -
i usually make things worse that way!! 8)

Ed


On Dec 29, 1:14*pm, Paul Clement
wrote:
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)