MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Controling User Entry


Posted by John on November 18, 2001 1:18 PM

Is there a way to restrict the movement of the cursor to predefined cells? I have a sheet that I only want the user to be able to select and edit specifice cells and I'm not sure how or if I can restrict the users selection. I know that I can lock and hide specific cells by protection and formating of the cells but I would actually like to restrict the selection too.


Posted by Stuart on November 18, 2001 4:53 PM

If you ensure all cells for entry are unlocked (via cell format, protection), and all cells for non-entry are locked, then you go to the VBA editor (Alt + F11). From the properties list for the relevant sheet, select xlunlockedcells for the enable selection criteria. HTH

Posted by anno on November 18, 2001 4:56 PM

john
you can lock the whole sheet, then go back and unlock only those cells you want the user to have access to, then protect the sheet. also, if you want to restrict the actual information a user can enter into a cell, use data validation on the data menu. the help topic for using data validation is quite good.