Run-time error '1004' - Application-defined or object-defined error

[Quadio]

Hi all,

"Run-time error '1004' - Application-defined or object-defined error"

I get the above error message when I run a particular line of code.

The relevant section of my code is below:

Please Login or Register  to view this content.

The code runs fine when the workbook is not shared but as soon as I share it the error appears.

Anyone know what I've done wrong?

Thanks

[Olly]

Yes - you've shared the workbook!

Some features of Excel just don't work in a shared workbook. Inserting hyperlinks seem to be one of them....

If it's essential, you'll have to unshared the workbook, insert the hyperlink(s), then re-share it.

[Quadio]

Oh I see haha, I thought there could've been a problem with the code. I added the linking option for other people to use rather than myself, so I'll just have to prompt them to unshare it before creating links.

Thanks for your time Olly