Shared Workbook Excel 2010

[mikeymay]

I have a workbook that will be stored in some sort of cloud facility which needs to be shared, to enable editing, with a number of users.

I was wondering if anyone has had any experience of doing this?

The file to be shared holds

• Conditional Formatting
• Data Validation
• Macros that run using button controls and on clsoing the file
• VBA driven user forms

Thanks

 

[jkpieterse]

1 and 2 work fine on OneDrive
3 and 4 are unavailable there.
Perhaps 3 and 4 can be avoided by cleverly using built-in functionality?