This may sound trite but I am having a problem with cell advancing when the worksheet is protected. Using the number pad to enter in information, if the worksheet is protected the enter key automatically moves the highlighted cell to the NEXT UNPROTECTED CELL instead of DOWN TO THE CELL BELOW. Is there any way to change the preferences so that it automatically advances to the cell below your current cell even if the worksheet is protected? I hope that this makes sense and thank you in advance for anyones help in this matter.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
protected cells acted differently on Mac excel 08
- Thread starter wonkabar
- Start date
-
- Tags
- enter key mac protected sheet
