Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel opening cell
Normally, when I select a specific cell and save a worksheet, the worksheet
will reopen at that spot. I have one work sheet that first opens at that spot, then immediately jumps to line 621 (no matter which cell was selected at last save). I do have three macros on the workbook, one to automatically format phone numbers entered in column C, and two to quickly apply formatting to cells when selected. None of these have any reference to line 621. Any thoughts or suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel opening cell
Hi,
With a very high level of confidence we can suspect that despite what you may think your macros are causing this to happen. Post them and someone will help. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "BrianW" wrote: Normally, when I select a specific cell and save a worksheet, the worksheet will reopen at that spot. I have one work sheet that first opens at that spot, then immediately jumps to line 621 (no matter which cell was selected at last save). I do have three macros on the workbook, one to automatically format phone numbers entered in column C, and two to quickly apply formatting to cells when selected. None of these have any reference to line 621. Any thoughts or suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel opening cell
Open the VBA editor by pressing ALT F11, and there display the
Projects window with CTRL R if it is not already open (typically on the left side of the screen). Expand the "tree view" for your workbook and open the Excel Objects "folder" and double click on the ThisWorkbook module. In that modules, look for code similar to Private Sub Workbook_Open() Range("A621").Select End Sub This code is executed automatically when the workbook is opened. Remove the entire procedure and save the workbook. Close the VBA editor and return to Excel. Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Fri, 12 Mar 2010 11:31:01 -0800, BrianW wrote: Normally, when I select a specific cell and save a worksheet, the worksheet will reopen at that spot. I have one work sheet that first opens at that spot, then immediately jumps to line 621 (no matter which cell was selected at last save). I do have three macros on the workbook, one to automatically format phone numbers entered in column C, and two to quickly apply formatting to cells when selected. None of these have any reference to line 621. Any thoughts or suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i set up opening a file from a cell in excel spreadsheet | Excel Discussion (Misc queries) | |||
how do i set up opening a file from a cell in excel spreadsheet | Excel Discussion (Misc queries) | |||
On Opening Excel WB the Active cell location never changes | Excel Discussion (Misc queries) | |||
Opening Excel at a particular cell | Excel Discussion (Misc queries) | |||
REF errors when opening excel in xp. works fine when opening wor. | Excel Discussion (Misc queries) |