Co Authoring VBA and Forms Controls

Mrock1

Board Regular
Joined
Oct 7, 2014
Messages
78
I’m relatively new to co authoring in excel as a collaboration tool and have found some behaviour that I can’t seem to find anything about.

My workbook is simple but makes use of some vba event handler subroutines and has some checkboxes with Marcos assigned. Simply put I've found that if I on one machine edit a macro in the VBE or add a new checkbox, the person on the other machine sometimes gets an upload error indicating that I am doing something in VBA or using forms controls (not activex if that’s important).
I haven’t been able to find and references to these situations but it means the6 other person loses their edits.

Empirically it seems to be a limitation of co authoring but the question is why? MS apparently knows about this because excel produces very explicit error messages, clearly indicating either VBA or forms controls and my user ID.

I hope someone can provide an explanation.

Many Thanks
Max
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,223,886
Messages
6,175,198
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top