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.
Bookmarks