+ Reply to Thread
Results 1 to 4 of 4

Tabbing thru Protected Cells

  1. #1
    Registered User
    Join Date
    03-02-2005
    Location
    Greenville, SC, USA
    Posts
    41

    Tabbing thru Protected Cells

    Is it possible to allow the tab key to work on a protected sheet the same as it does on an unprotected sheet? By this I mean, when I protect a sheet the tab key will only take me to unprotected cells and I want to tab anywhere just not be able to change the data.

  2. #2
    Registered User
    Join Date
    11-20-2006
    Posts
    23
    When you protect the sheet 'tick' the "select protected cells" tickbox and the "select unprotected cells" tickbox, as seen in the attachment.
    Then when you tab about you will be able to select any of the cells in the worksheet.

    Dfire
    Attached Images Attached Images

  3. #3
    Registered User
    Join Date
    03-02-2005
    Location
    Greenville, SC, USA
    Posts
    41
    Thanks!
    Tried it but when I hit the Tab key it still only takes me to cells that are unprotected (when I go to a5 and hit tab it will not take me to a6 but back to a1). I can click on them put wanted to tab normally if possible.

  4. #4
    Registered User
    Join Date
    11-20-2006
    Posts
    23
    Your quite right, I've not really noticed this before.... but 'Enter' and the arrow keys will navigate to whichever is the next cell, but tab jumps to the next unprotected cell....this must be an Excel-ism, sorry I can't help further.
    Dfire

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1