Hello,
I have made a macro-enabled sheet that uses the Prevsheet vba function. It all works great, but I have found that if I have another excel workbook (completely separate) open it will pull from that as the previous sheet if I update anything in that book. When I go back to the intended workbook and click a cell and hit enter it will update back to what I want.
Is there any way I can have it stay to only inside of the intended workbook?
If I turn off automatic updates then the problem goes away, but I would like it to be able to have the auto on since there are a lot of moving parts.
Any suggestions?
Thanks!!
I have made a macro-enabled sheet that uses the Prevsheet vba function. It all works great, but I have found that if I have another excel workbook (completely separate) open it will pull from that as the previous sheet if I update anything in that book. When I go back to the intended workbook and click a cell and hit enter it will update back to what I want.
Is there any way I can have it stay to only inside of the intended workbook?
If I turn off automatic updates then the problem goes away, but I would like it to be able to have the auto on since there are a lot of moving parts.
Any suggestions?
Thanks!!