Ignoring read-only prompts in macros

Hi all. I have a very large Excel macro that I run daily. It consists of opening several other worksheets, copying specific cells and then pasting the values of those cells in another workbook. Usually, the other worksheets are open at other workstations and therefore, the macro prompts me to open as read-only. I click "read-only", it does its thing and then it asks me if I want to save the changes. I always click "no".

Furthermore, after I run this macro, Excel is pretty much unusable unless I close the program and re-open it. It seems that it keeps some things in its "memory" and when those other worksheets become available for read-write, it asks me if I want to open it again. I don't mind clicking out of it, but the slow Excel is definitely a problem. Every click requires a waiting time and it frequently locks up altogether.

My questions are:

a) Is there a way to get it to automatically open as read-only and not save changes?
b) What can I do to clear whatever it's doing in the background so I can use Excel again without closing?

Thanks,
sara

Originally Posted by royUK

To open a workbook read only

Please Login or Register  to view this content.

To prevent prompt to save

Please Login or Register  to view this content.

Not sure what the other problem is, but it often helps to clear the memory e.g.

Please Login or Register  to view this content.

Thank you, that worked perfectly.

This also seems to have taken care of the slow Excel problem, so thanks!