Thanks for your reply.

I don't think it is an access problem as I have opened the file without trying to run the macro without any problems and as I am running the pages locally rather than remotely.

It's just when I try to run the macro that I get that error.