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

--
Regards
Frank Kabel
Frankfurt, Germany

"andy gilhooly" schrieb im Newsbeitrag
...
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