![]() Open the worksheet you will auto-highlight the row and column of active cell, right click the sheet tab and select View Code from the context menu. There's got to be an easier way then re-installing every time this happens. The following VBA code can help you automatically highlight the entire column and row of the current cell in worksheet, please do with following steps: 1. She should be able to make changes to it. ![]() It's not a permission issue or read only file. Locking specific cells in a Microsoft Excel spreadsheet can be very handy, especially if you’re sharing the sheet with others. If you entered a password, enter it and click OK. 2) If you didn’t enter a password, the sheet will return to unprotected immediately. This worked for about a month and now she is having the same issue with her new Excel 2003 installation. 1) Go to the Review tab and click Unprotect Sheet. I resolved this issue once by removing Excel 2000 and installing all of her Office apps from the same Office 2003 installation. You have to use task manager to close the window after this happens. The cursor is then stuck and you cannot release the selection, if you try to close the window with the red X, the cursor keeps selecting cells in the upper right hand corner of the doc and you cannot close the window. If she double clicks a cell the only thing that happens is she can select multiple cells and has the big plus sign cursor. ![]() I have an end user who was having problems typing into cells in Excel 2000.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |