Mutli-user form access

Hi there,

I was wondering if anyone had a solution to this as I am a little bit stuck at the moment!

I have produced a userform via VBA, where the data is copied accross;

Please Login or Register  to view this content.

The form works fine - I am not worried about protection, as I have the data sheet hidden - may require amendment by multiple users anyway. I have found that it could be a problem with mutliple users. The obvious option is the 'Share' solution, but my understanding is that is not possible to do this - am I right?

Thanks in advance

Userforms & VBA will work in a shared workbook. You cannot change the code once shared, the book must be unshared for any changes in the code then sharing allowed again