Protecting Cells/Sheets in Excel

Chrisa10

I have seen some excel spread sheets where the cells which you can 'click' (select) are limited to just a handfull. Also the scroll bars are removed and dont know if this is linked.

I know how to add sheet protection and to lock/unlock cells - excel shows an error message if you try to edit protected cells - but i dont know how you restrict the selection of the cells to a few and then apply a tab index between the selectable cells.

Any help greatly appreciated

Chris

More4me

This is from Excel Help
Protecting elements from all users You can prevent users from inserting, deleting, and formatting rows and columns, from changing the contents of locked cells, and from moving the cursor to cells that are locked or to cells that are unlocked.
By default all cells on a worksheet are locked. Before you protect a worksheet, you can unlock cells where you want users to enter and change data, in two ways. To unlock cells for all users, you can use the Protection tab of the Format Cells dialog box. To unlock cells for specific users, you can use the Allow Users to Edit Ranges dialog box. Any ranges that you specify in this dialog box and don't assign a [URL="mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\Office10\1033\xlmain10.chm::/html/xlconAboutProtectingWorkbooksWorksheets.htm#"]password[/URL] for are also unlocked for all users. The cells you leave locked become protected only after you protect the worksheet.

for removing scroll bars I suggest you go to Tools/Option/view tab and uncheck scroll bars prior to protecting the worksheet/workbook.

Hope this helps

Chrisa10

thanks a lot - i was being a numpty.

I was able to protect the worksheet ok, but i just wasnt reading the check-box options properly, with one of the first ones relating to the selectability of the locked/unlocked cells!

:T :beer: