I want to disable cell A2 so when you tab from A1, it skips A2 completely and brings you to A3. I've tried to protect, unprotect, hide, unhide, the cells and then did the same to the worksheet, but that seems to only effect formatting. I want the text in the cell to stay there, but for the cell to be completely non-functional. Any suggestions?
First, you have to select the entire sheet (or at least the rectangular portion of it that will contain cells that you want to use)... then go to Format|Cells and from the Protection tab, deselect "locked cells"
Then select only the cells you want to lock and go back to the Protection tab and re-select the "locked cells" checkbox.
Click Ok.
Now you can go to Tools|Protection|Protect Sheet... and deselect "select locked cells" and click Ok.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks