I have a workbook that has code for a VB label. The label width may be altered by inbuilt VBA code that enacts when the worksheet is activated.

This works fine when the workbook is in single user mode, but when I switch the workbook into shared mode the line

Label1.Width = <numeric val>
causes the following error:

runtime error 1004
Unable to set width proprty of the OLE object class

Has anyone seen a similar problem to this and how can I get this to work in when in shared mode?

Thanks