I have a workbook which has a sub that sends a sql query to an external
(Oracle) database. When I check the share workbook property so that
changes can be made by 1+ users at the same time, the sub returns the
following error:

"Run-time error '1004': this command is not available in a shared
workbook"

I can see why there is a restriction on doing this in a shared workbook,
but is there any workaround?

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!