Hi. We are using a shared workbook in Excel 2003. There are 32 sheets in the wb being used by 7 people at various times. The layouts of the sheets are identical. The three routines in the code set frames on each worksheet at B9, hide two columns when printing, and inserts a row and copies down the formulas in columns O, P and Q when a cell is double-clicked. Columns M-Q of each sheet are used only by one particular individual. Ever since I added the code below to the wb, this user has reported that occasionally when she saves the file (which she does every time she completes data entry for a sheet) the active cell has changed to B9 on a difference sheet from the one she was on when she saved. I have not witnessed this, but since she reports B9 as the destination cell when this occurs (the same cell the frames are set to), it can't be coincidental. But I can't see any reason for this to happen (of course, I am a beginner at VBA.) I have also uploaded a blank copy of the file. The file opens on the last tab of the workbook, but the two sheets with red tabs were the two most recently involved. The save was performed on WSAW and the active cell went to KBTX. Thanks for your help!
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks