There's been no problem for years, it did have this problem once before. But I didn't write the fix down, or lost the fix. This just happened the other day.
I suspect it may be onecare related.. onecare is changing all my office security settings to high. And I can't stop it from doing it. So it's probably the source of this problem. And I'd need a way to make it permanent that onecare's security changing would have no effect.. I have a shopping list.. left 1st column A1 is text items to shop for [top label is items] Top row is labels of how to operate on the different items, cost, store aisle, how many needed, how many on hand etc.. with a total cost at the very bottom row 61 on down. To prevent the cost items from getting sorted I gave those items a prefix of [Z] to keep them locked at the bottom of the sheet. I've had this set to NOT sort row 1 before, at least a year. This problem has occurred before. But I can't remember how I fixed it. I put the cursor on B2 and hit freeze. that worked for scrolling down and left keeping items in place, and scrolling down, it kept row 1 in view. I also tried split, but that's most definitely not what I've been using for years. I've locked with freeze the top row, and left column. Trouble is when I sort the 1st column [items], it also sorts row 1.. Would be nice to know exactly what changed my settings, and what I need to set to get the sheet back to it's previous state with row 1, column 1 locked, but separate to allow sorting the items alphabetically. --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
