Problems Distributing a Shared Workbook

[Dominic]

Hi

I have created an excel workbook to automate some menial administrative
tasks normally acomplished through kludgy web interfaces using a web query
and some buttons.

This works fine for me. However when I try and run the workbook on anyother
team member's machine it dies with the error:

Runtime error '1004':
This command is not available in a shared workbook.

The strange thing is that I never made this a shared workbook. For some
reason the shared workbook options under 'Tools' are greyed out. One of the
solutions mentioned in MS help was to 'Save As' the workbook to another
location. This doesn't help.

Does anyone know how to fix this problem?

Thanks,
Dominic

 

[NickHK]

Dominic,
Wild guess, but is the file Read-Only ?

NickHK

 

[Dominic]

Heh, good point, but no, it is writeable.

Dominic,
Wild guess, but is the file Read-Only ?

NickHK

 

[T588]

Is the sheet or workbook protected ?
Try unprotecting it.