Forum Discussion
Solved
How do I have Excel treat each file separately - for search, undo, etc.
Excel treats all files I have open as one. By that I mean there is one search box that works across all files open. If I want to search for different things in different files, I have to keep changin...
I thought I had wrapped this up by saying that the option to start independent instances of Excel by using the /X startup option is my solution. This makes each file independent with separate undo and find/replace boxes. But, I did not see that this morning when MS asked me to indicate the best solution. mathetes
Here a small solution with VBA is a bit more cumbersome, but it does its job. Maybe it will help you as a preliminary solution.
Best regards,
Nikolino
I know I don't know anything (Socrates)