Checkbox in shared workbook

Hello,

May I know if CheckBox class can be used when shared workbook function is on? In fact, I have created a worksheet with a bunch of checkboxes and a vba code was built so that all those checkboxes could be selected by checking the first checkbox, i.e. "select all". The code was error-free and everything was fine until the shared workbook function was on. Whenever the macro is initiated (by ticking or unticking the checkboxes), I got the error message 'Run Time Error 1004 Unable to Set the Value property of the CheckBox Class'.

I just wonder if Checkbox class are forbidden for shared workbook, or if there is any other possibility which makes my code not working.

My code is as below.

Please Login or Register  to view this content.

Can anyone give help....?