why is select method invalid when sharing

  • Thread starter Thread starter andy gilhooly
  • Start date Start date
A

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
 
Hi
are you able to change the color manually in a shared workbook?. AFAIK
this is not possible for shared workbooks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 causes error with Excel 2000 VBA code 6
Checking if a font is installed (2007) 3
Start up file doesn't open 1
is there a property instead of ScaleWidth method 2
Select method failing 1
Show shape on cell select, Hide shape when cell is deselected 5
Excel macro error when workbook is shared 0
Problem with ScaleType propert for Axis object 1

Back
Top