I have two worksheets automatically pulling in stock prices. While Im typing anything in any cell in Worksheet A, all of a sudden Worksheet B will come to the front and I now find myself typing in Worksheet B. AutoSave is turned off. I saw this a few months ago, but it went away for some unknown reason, and now its back again. I dont know if there is an Excel Setting that controls this behavior.
Has anyone seen this before? THANKS!
The only things I can think of are:
A) have you got HYPERLINKS between sheet A and sheet B that you are inadvertantly triggering?
B) does your spreadsheet include any VBA routines that might be changing the active sheet?
I can't think of anything "standard" that might be causing this effect.
Mark.
[/QUOTE]Originally Posted by Mark@Work
Thanks Mark! Definetely do not have any hyperlinks. We do have a bunch of VBA routines in one of the two spreadsheets that we're combing over right now. I appreciate your suggestions!
Last edited by cboexcel; 03-05-2008 at 04:31 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks