why is select method invalid when sharing

[andy gilhooly]

This is a perfectly valid piece of code until I switch on
Sharing to enable a spreadsheet to be shared on a network
drive:
ActiveSheet.Shapes(strBlackButton).Select

I get the following error:
Run time error '-2147467259(80004005)':
Method 'Select' of object 'Shape' failed

Why doesn't this work when the spreadsheet is shared?
Is there another way to reference the button in order to
change its font colour?
Regards
Andy

 

[Frank Kabel]

Hi
are you able to change the color manually in a shared workbook?. AFAIK
this is not possible for shared workbooks