+ Reply to Thread
Results 1 to 2 of 2

Block cells for selection

  1. #1
    Forum Contributor
    Join Date
    04-05-2007
    Location
    Arlington, TX
    MS-Off Ver
    Office 2010
    Posts
    164

    Block cells for selection

    Is it possible to block a cell from being selected? I just want to hop over some cells when I'm tabbing down the row... I wrote a macro that copies all the formulas from the row I am on to the next new row, so it can't have an effect on anything within the cells, just not allow them to be selected, since they just for display.

  2. #2
    Forum Contributor
    Join Date
    06-21-2005
    Location
    Cambridge, England
    Posts
    118
    If you unlock all cells that you want to allow selection (format, cells protection, locked)
    and then enable protection (tools, protection, protect sheet)

    The tab key will take you to just the unlocked cells.

    R

+ 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