| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
why is select method invalid when sharing
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
why is select method invalid when sharing
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error: method 'select' of object_worksheet' failed | Excel Discussion (Misc queries) | |||
| RUNTIME ERROR '1004' --- Select method of worksheet class failed | Excel Programming | |||
| Select method of Range class failure | Excel Programming | |||
| Help with Select Case or Best Method | Excel Programming | |||
| error 1004 Select method of Range class failed | Excel Programming | |||
Hybrid Mode
