Sharing workbook causes error 1004

[Roundbarrow]

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

[Roundbarrow]

Ok, just found out that OLE objects are not available in shared workbooks:
http://support.microsoft.com/kb/130560/en-us
So does anyone know of a way of switching code in /out depending if in shared mode or not?