I've written/recorded a macro that copies certain sheets from one workbook to another. It works fine when I am the only person in the workbook or if I select to open it read only, but if there is someone else in the workbook when I open it then it fails.
Trying to run the macro produces this error message:
"Run-time error '1004': Select method of Sheets class failed"
on this line:
"Sheets(Array(4, 6, 9, 10)).Select"
I have found a work-around by making the whole workbook read-only but I'd love to know why it does this.
Can anyone put me out of my misery?
Trying to run the macro produces this error message:
"Run-time error '1004': Select method of Sheets class failed"
on this line:
"Sheets(Array(4, 6, 9, 10)).Select"
I have found a work-around by making the whole workbook read-only but I'd love to know why it does this.
Can anyone put me out of my misery?